The discussion was a learning experience for me as well, (again I learned the DBI and DBD can do!) David Kirol "T. Murlidharan Nair" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi All: > > This for the benifit of all. I had a wonderful time discussing this > topic > with David Kirol (one of the members in the list) and was finally > able to > solve it. > David had the following comments > " I can think of two approaches. The first involves dynamically > creating a > temporary table to hold the result set your procedure currently > prints, then > using a Perl/DBI query to fetch the results in a while loop (as you > tried in > the script below). The other approach is actually easier to dream up > than it > is to realize, and infact may not work with the perl DBI module. It > goes as > follows: > Create a package and define in it a REF CURSOR and a function or > procedure > to accept the query parameters and return the REF CURSOR. That much > is > straight forward (and works from SQL*+) but I am stalled as to how to > handle > the returning REF CURSOR in perl/DBI > HTH " > > For handling the perl/DBI part use the DBD::Oracle qw(ORA_RSET) > > I was actually able to get it to work. > Cheers always!! > Murli
-- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
