Re: 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
To expand upon that thought, the following resources will come in handy: a) Some DBI/Oracle Examples b) An example of a working Oracle function Celebrate Intellectual Diversity	[reply]
Re^3: I need Perl stored procedure help (against Oracle DB) by danstout49 (Initiate) on Mar 02, 2006 at 15:28 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	[reply]