Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling

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:
      Yes, recent versions of DBD::DB2 allow fetching the procedure return value. See rt://42185.
      Here is what my code looks like:
      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?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://579578]
[Corion]: I spent parts of yesterday digging into Filter::Simple to make it not change the line numbers of unfiltered code, but I think I need regex help (which will come in a SoPW I guess). I tried @lines = /((?:"...."|[^" \n]+)\n)/gs, but that matched on...
[Corion]: ... foo "\0\0\0\n" bar\n by matching the first \n instead of matching the four-bytes-in- double-quotes part
[Corion]: ... and I still don't understand why ;)
[Corion]: This is because Filter::Simple does some string-trickery, replacing all string literals with "quoted packed numbers"
[Corion]: I fear this might be a bug in the RE engine, but if it is a bug, even fixing won't help me because I need Filter::Simple for Filter::signatures , which provides signatures as a backwards compatibility feature for Perl <5.22 - and these ...
[Corion]: ... won't get a fix anyway ;) My plan B is to encode the string placeholders avoiding \r and \n

How do I use this? | Other CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (12)
As of 2017-01-23 08:06 GMT
Find Nodes?
    Voting Booth?
    Do you watch meteor showers?

    Results (191 votes). Check out past polls.