Function Call from Access to Oracle

[Fahim]

Hi All,

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

Appreciate any feedback.

 

[Albert D. Kallal]

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

 

[Fahim]

Albert,

Works like a charm, now its too easy.
Thanks,
Fahim