Calling Oracle Procedures from MS Access 97 and 2000

[DanL]

I need to call an Oracle 9i stored procedure from a MS
Access 97 or MS Access 2000 database. I could convert the
stored procedure to a function is this results in an
easier implementation.

I already link to Oracle 9i tables via ODBC drivers.

Any thoughts,

Thanks

 

[Anne Nolan]

I need to call an Oracle 9i stored procedure from a MS
Access 97 or MS Access 2000 database. I could convert the
stored procedure to a function is this results in an
easier implementation.

I already link to Oracle 9i tables via ODBC drivers.

Any thoughts,

Thanks

This has worked for us, with Oracle 8i:

Create a pass-through query in Access.

If your stored proc is a procedure, put something like this in the SQL
for the query (complete with the curly brackets):
{call MyProc('mystring')}

If it's a function (returns a value), use something like this (no
brackets):

select MyProc('mystring') from dual;

Hope this helps,

Anne Nolan