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]
