Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things
 
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
Replies are listed 'Best First'.
Re^2: Getting return value of DB2 stored procedures
by iguanodon (Priest) 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 perusing the Monastery: (3)
As of 2016-02-13 09:25 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How many photographs, souvenirs, artworks, trophies or other decorative objects are displayed in your home?





    Results (422 votes), past polls