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

Re: Getting return value of DB2 stored procedures

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


in reply to Getting return value of DB2 stored procedures

How about this?

Neil Watson
watson-wilson.ca

  • 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
Domain Nodelet?
Node Status?
node history
Node Type: note [id://579572]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others chanting in the Monastery: (3)
As of 2024-04-24 02:03 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found