Call Oracle Stored Procedure

  • Thread starter Thread starter Frank
  • Start date Start date
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
 
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"
 
Back
Top