http://www.perlmonks.org?node_id=579578


in reply to Re: Getting return value of DB2 stored procedures
in thread Getting return value of DB2 stored procedures

That example also doesn't bind a return value, but then the procedure doesn't return anything. In my example the return value is the first place holder before the =call. Where I work the convention is for stored procedures to return a value indicating success or an error code to indicate what went wrong, so I'd like my Perl code to stick to that if possible.

  • Comment on Re^2: Getting return value of DB2 stored procedures

Replies are listed 'Best First'.
Re^3: Getting return value of DB2 stored procedures
by shanknbake (Initiate) on Jan 22, 2013 at 02:27 UTC
    Did you ever figure this out? I've been trying my heart out to figure out why a stored procedure that I'm calling is not returning a value.... Here is what my code looks like: http://pastebin.com/Sih7L2mU
      Yes, recent versions of DBD::DB2 allow fetching the procedure return value. See rt://42185.
      Here is what my code looks like: http://pastebin.com/Sih7L2mU
      If you're still having trouble and you want someone to look at your code, post it here. See How do I post a question effectively?