Re: Binding OUT variables in Perl
Posted by:
jphekman
Date: May 16, 2006 01:24PM
Thanks!
After reading the post to which you linked, I discovered that you can:
* make one call in which you call the procedure (you can just reference the OUT variable by name and don't have to specifically set it -- apparently MySQL doesn't care if it's previously declared)
* make a completely separate call in which you select the value of that variable ("SELECT @out") and fetch the results
Note that they must be two separate calls; if you put them together in one call, things break. (Apparently if you call fetch(), the first statement must return a value, and that's the value that's fetched, so if you "SELECT 1; SELECT 2;" then 1 is returned, not 2).
Anyways, it's a working workaround. Thanks again.
Subject
Written By
Posted
Re: Binding OUT variables in Perl
May 16, 2006 01:24PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.