Retrieving a value from an ORACLE stored procedure

[jonnymadill]

Hi folks,

I have an ORACLE stored procedure, which accepts two parameters and returns one, I want to pass in two string values from VB6 and retrieve the result date parameter from the stored procedure. At the moment no cursors are involved.

I am connecting to the db using a simple Oracle objects connection.

Any help would be greatly appreciated, I've been going round in circles!

Thanks again,
jonny,

 

[SIG357]

Try using ADO as the Connection method, then using the ADO.Command object to execute the SP. The Command object lets you specify parameters, parameter direction, etc. and rettrieve output parameters or just a simple return value. Check back in if you need help with the syntax.

 

[jonnymadill]

Thanks for the help SIG357. I managed to solve my problem just there now, I used the following link as a guideline..

http://home.fms.indiana.edu/users/c.../oracleoUsing_ExecuteSQL_and_CreateSQL_t.html

If you go up a level on the link above (ie.

http://home.fms.indiana.edu/users/cshelton/oracle/server.815/oracleo/

) its provides some very useful info.

Thanks again.