Tim,

Oracle 8.1.7
DBI 1.28
DBD::Oracle 1.12

I hope this email does not irriatate you but I really need some help. I have an Oracle 
DBA I need to work with who doesn't seem to how to write PL/SQL for Perl DBI. He 
insists on writting stored procedures which loop through the results set  
fetching the data into output variables. The problem is I can't seem to figure out how 
to get all the data from it.

I found an example of an oracle FUNCTION returning a cursor which allowed me to fetch 
the data from Perl. Unfortanely, the DBA is complaining that the returned cursor and 
the results set are static and will cause a memory leak. He insists on using a 
package, which I know how to accomodate, however he still is using the looping to 
output variable contained in the package stored procedure.

What can I do. How can I explain the problem to him? Your assistance is very much 
appreciated.

Thank you in advance,

Michael Cesar
Biggs-Gilmore, Interactive Development

Reply via email to