Oracle procedure

[gys67]

Hi,

I have a function written in the Oracle database that I'm using in my MS access application. How can I make a call to this function using VBA?

Thanks very much!!!

 

[jrbarnett]

If you need to return a value from it, create a pass through query using the code then execute it in a recordset option - and retrieve the return values.
If its an action query (insert/update/delete) then create it as a pass through query and execute it as a querydef object.

John

 

[gys67]

Thanks so much John... That helped partially...
Actually I'm trying to Validate an ID that will be entered by the user. So, what I would like to do is have a command button called Validate which when clicked should fire the pass-through SQL query that I have already created and based on the value returned give an appt message in the message box.

How can I call this pre-created query in my VBA code?

I really appreciate your help... thanks!

 

[gys67]

I have created a pass-through SQL query in my Access application and I would like to fire this query using a command button. How can I call this query in the "On click" procedure in my VBA code?

Thanks much!!!!