Return value from Oracle Stored Procedure *SOLVED*

Hi,

I am calling a stored procedure in a VB6 app - there are 6 IN/OUT variables being passed - however, none of them seem to return a value back to my calling code.

I have encountered this problem before - I tried everything! I wrapped the procedure in a function call with a return value - still nothing...! It is getting very frustrating now! Can anybody help me? Does anybody have an example of how to get a value back from a procedure call in VB with Oracle?

Hoping....
DJ

Can you post some of your code ? so that we can see what are you trying to do ?

Hi,

After thinking about this a lot, I have sussed it out. I was passing a variable into a parameter and then using the contents of the variable after my Execute command. I then realised that if there was a return value it would be in the parameters collection!

So, to answer this for anybody else, just make a call to command.parameters(0).value to get the results.

DJ