Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses
 
PerlMonks  

Re^2: Getting return value of DB2 stored procedures

by iguanodon (Curate)
on Oct 20, 2006 at 13:34 UTC ( #579578=note: print w/ replies, xml ) Need Help??


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
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?

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://579578]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others perusing the Monastery: (6)
As of 2014-09-19 03:45 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How do you remember the number of days in each month?











    Results (129 votes), past polls