execute oracle'queries from access

  • Thread starter Thread starter carlier
  • Start date Start date
C

carlier

did you know the code for executing stocked procedures
in oracle from access ???

in advance , many thanks
 
Create a Pass-Through query in Access with the SQL something like this
(works for me with Access 97, 2K, 2K2, and Oracle 8.1.7):

If your stored procedure is a PROCEDURE (no returned value):
{call MyOracleStoredProc(param1, param2)}

If your stored procedure is a FUNCTION (returns a value):
select MyOracleFunction(param1,param2) from dual

If your functions have no parameters, you can omit the parentheses.

Anne Nolan
 
Back
Top