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.
Does the procedure return a single set of values with each call? If so just fetch() in a loop. If its returning an array, use a package of your own to unwrap it. An example would make it easier for us to guess which it is and offer better suggestions.
-- Mac :}) ** I usually forward private questions to the appropriate mail list. ** Ask Smarter: http://www.catb.org/~esr/faqs/smart-questions.html Give a hobbit a fish and he eats fish for a day. Give a hobbit a ring and he eats fish for an age.