ant has asked for the wisdom of the Perl Monks concerning the following question:
Hi Folks
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
Ant
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
Ant
|
---|
Replies are listed 'Best First'. | |
---|---|
Re: PL/SQL Functions.
by jorg (Friar) on May 29, 2001 at 16:12 UTC | |
Re: PL/SQL Functions.
by busunsl (Vicar) on May 29, 2001 at 16:25 UTC | |
by jorg (Friar) on May 29, 2001 at 18:23 UTC | |
Re: PL/SQL Functions.
by arturo (Vicar) on May 29, 2001 at 16:29 UTC |
Back to
Seekers of Perl Wisdom