Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"
 
PerlMonks  

Re: Getting return value of DB2 stored procedures

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

Comment on Re: Getting return value of DB2 stored procedures
Re^2: Getting return value of DB2 stored procedures
by iguanodon (Curate) on Oct 20, 2006 at 13:34 UTC
    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.

      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://579572]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others contemplating the Monastery: (10)
As of 2014-12-19 10:58 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    Is guessing a good strategy for surviving in the IT business?





    Results (78 votes), past polls