execute oracle'queries from access

[carlier]

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

in advance , many thanks

 

[Anne Nolan]

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