in reply to I need Perl stored procedure help (against Oracle DB)

You may or may not be able to get data out of a PL/SQL block using DBI, but if you use a function instead of a procedure, you can call it in a SELECT statement, and you will be able to fetch the data using DBI in the same way as you get it from any SELECT statement.

Caution: Contents may have been coded under pressure.
  • Comment on Re: I need Perl stored procedure help (against Oracle DB)

Replies are listed 'Best First'.
Re^2: I need Perl stored procedure help (against Oracle DB)
by InfiniteSilence (Curate) on Feb 23, 2006 at 22:43 UTC
      Sorry for the long delay in response, have been working on another problem lately. I found a work-around that seems to work fine in the Oracle Example link you sent. Thanks, dan