On Tue, 29 Jul 2003 16:05:39 -0500 "Galbraith, Mark" <[EMAIL PROTECTED]> wrote:
> I have been asked to call a stored procedure, and then use the value > stored in a variable inside the package. I've looked at the > documentation, including the appropriate chapters in Programming The > Perl DBI (O'Reilly). > > I found that by changing the procedure to a function, I can call the > function and bind the variable using bind_param_inout(). My question > is, is this the only way to do this? Is there a better way? Look at the examples in the fine manual. There are also working examples in Oracle.ex/. `perldoc DBD::Oracle` http://search.cpan.org/dist/DBD-Oracle/Oracle.pm http://search.cpan.org/src/TIMB/DBD-Oracle-1.14/Oracle.ex/proc.pl -- Mac :}) ** I usually forward private questions to the appropriate mail list. ** Ask Smarter: http://www.catb.org/~esr/faqs/smart-questions.html Give a hobbit a fish and he eats fish for a day. Give a hobbit a ring and he eats fish for an age.
