Function Call from Access to Oracle

  • Thread starter Thread starter Fahim
  • Start date Start date
F

Fahim

Hi All,

How can I call an Oracle stored procedure or a function
from Access97?

Appreciate any feedback.
 
Put your code call right into a query..and make that query pass through.


exec sp_MyCoolStoredProc


Then save the query...as any name..perhaps lets say qryMyCoolProc

Now..to run..

currentdb.Execute "qryMyCoolProc"

I "think" the above should work...if not..then try:

currentdb.QueryDefs("qryMyCoolProc").Execute
 
Back
Top