Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer
 
PerlMonks  

Re^2: Getting return value of DB2 stored procedures

by iguanodon (Priest)
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
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?

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: (13)
As of 2015-07-08 02:46 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (93 votes), past polls