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
