Call Oracle sp w/ input and output parms

S

Sue

I am trying to call an oracle 9i stored procedure from MS
Access 2000, but am failing miserably.

Does anyone have a simple sample code for doing that? The
oracle procedure works fine (I tested in oracle), but I
get a syntax error when calling the sp.

I tried just using the simple query interface with a pass-
through query, but that doesn't seem to handle output
parameters. As I am new to Access, I don't know the
syntax for setting up a call and getting a results set.
Any help would be greatly appreciated!

Thanks,
Sue
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Pass-Through To Oracle 10g Stored Procedure - Return Result 1
Acess 2000 - calling oracle user-defined function 3
Access pass-through query to Oracle 10g stored procedure - results 1
how to call Oracle Stored Procedure from MS ACCESS 2007 VB 5
Using Excel to call Oracle Stored procedure. 1
ODBC Connection Not Connecting 13
Pass-Through Query Error 1
Stored Procedure Date Parameter Conversion 4

Top