ACC2: No Results When Calling ORACLE 7.0 Stored Procedure

MORE INFORMATION

ORACLE version 7.0 stored procedures are PL/SQL blocks (that is, they are not queries). PL/SQL procedures are similar to PASCAL procedures. They, like SQL Server procedures, can accept IN, OUT, or IN-OUT parameters, and can contain functions that return values.

The only procedures that you can call in ORACLE version 7.0 from Microsoft Access are those that require IN parameters. To do this, construct the statement as

   {call StoredProcXX(Arg1, ...)}
				

by concatenating the name of the procedure and its arguments.

There is no concept of a stored function in the ORACLE ODBC specification; therefore, you cannot call stored functions. The same is true for ORACLE packages which are ADA-like constructs (data and methods wrapped in a package). To invoke a procedure in a package in ORACLE version 7.0, preface the procedure or function with the package name. For example:

   PackageAA.ProcedureXX(Arg1, Arg2,...)
				

This is not possible with the current ORACLE ODBC driver.