Results 1 to 3 of 3

Thread: Return value from Oracle Stored Procedure *SOLVED*

  1. Feb 3rd, 2004, 09:14 AM #1
    DJ_Catboy
    DJ_Catboy is offline

    Thread Starter
    Addicted Member DJ_Catboy's Avatar
    Join Date
    Jan 2003
    Location
    Suffolk, UK
    Posts
    159

    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
    Last edited by DJ_Catboy; Feb 3rd, 2004 at 09:51 AM.
  2. Feb 3rd, 2004, 09:34 AM #2
    a00
    a00 is offline
    Addicted Member
    Join Date
    Aug 2003
    Location
    Earth
    Posts
    139
    Can you post some of your code ? so that we can see what are you trying to do ?
  3. Feb 3rd, 2004, 09:50 AM #3
    DJ_Catboy
    DJ_Catboy is offline

    Thread Starter
    Addicted Member DJ_Catboy's Avatar
    Join Date
    Jan 2003
    Location
    Suffolk, UK
    Posts
    159
    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
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width