Call Oracle Stored Procedure

F

Frank

Hi,

How can I execute Oracle stored procedure from Access XP?
I tried with Pass through Query,

Any tips will be apprecited
Thanks
 
A

Albert D. Kallal

Just make a new query, and make it pass through. Put in side the command to
execute the proc. (the follwing would be for sql server..and I don't know
the syntax for Oracle...but you likey do...).

Execute sp_MyStordedProc


Now, save the abvoe query. To run the store proc, just go:

currentdb.Execute "NameOfPassThoughQueryYouSavedAbove"
 

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
Stored Procedure Date Parameter Conversion 4
Access pass-through query to Oracle 10g stored procedure - results 1
Using Excel to call Oracle Stored procedure. 1
how to call Oracle Stored Procedure from MS ACCESS 2007 VB 5
execute Oracle procedure 2
Executing Stored Procedure from Access 0
sql stored procedure 1

Top