--- "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?
The DBD::Oracle documentation demonstrates how to bind IN OUT parameters from PL/SQL procedures; doesn't have to be a function. http://search.cpan.org/author/TIMB/DBD-Oracle-1.14/Oracle.pm#PL_SQL_Examples ===== -- Andy Hassall ([EMAIL PROTECTED]) icq(5747695) http://www.andyh.co.uk http://www.andyhsoftware.co.uk/space | disk usage analysis tool ________________________________________________________________________ Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://uk.messenger.yahoo.com/
