|No such thing as a small change|
PL/SQL Functions.by ant (Scribe)
|on May 29, 2001 at 15:03 UTC||Need Help??|
ant has asked for the
wisdom of the Perl Monks concerning the following question:
I have been using the Perl DBI to access and return data
from an Oracle database using PL/SQL packages and procedures.
By using param_inout (e.g. bind_param_inout(6,\$result,252);)
I can return the data from the database.
But how do I return data from a PL/SQL function? If the function
takes in 4 parameters and returns a number, do I use 5 binded
variables and the 5th variable is the returned number (does
not seem to work)
or is there another way?? Thanks for any help in advance