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.
| [reply] |
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
| [reply] |
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?
| [reply] |