Get multiple rows in Perl from Oracle

kalyanrajsista has asked for the wisdom of the Perl Monks concerning the following question:

Hello all,

Is there any module which returns multiple rows from Oracle db when I execute any stored procedure or function inside it

Please help me out .. Thanks a ton in advance.

Comment on Get multiple rows in Perl from Oracle

Replies are listed 'Best First'.
Re: Get multiple rows in Perl from Oracle by Corion (Patriarch) on Dec 24, 2009 at 10:10 UTC
Have you looked at DBI?	[reply]
Re: Get multiple rows in Perl from Oracle by marto (Cardinal) on Dec 24, 2009 at 11:21 UTC
As Corion suggests, this is covered in detail within the DBI documentation. See also Reading from a database from the tutorials section, but the documentation should be more than sufficient. Martin	[reply]
Re^2: Get multiple rows in Perl from Oracle by kalyanrajsista (Scribe) on Dec 24, 2009 at 11:54 UTC
I agree that DBI does lots of things, but I'm trying to execute a stored procedure which returns data rows. I'm successfully executing procedure and is returning only the last row from DB output. How can i get all the rows I'm trying the following modules.... `use DBIx::Connection; use DBIx::PLSQLHandler;` [download]	[reply] [d/l]
Re^3: Get multiple rows in Perl from Oracle by Corion (Patriarch) on Dec 24, 2009 at 12:13 UTC
The documentation seems fairly explicit. You could show us some code, but that would spoil the fun of extracting the relevant information piece by piece from you. So, my next question is, is it a mineral?	[reply]
Re^4: Get multiple rows in Perl from Oracle by kalyanrajsista (Scribe) on Dec 24, 2009 at 12:25 UTC
Re^5: Get multiple rows in Perl from Oracle by Corion (Patriarch) on Dec 24, 2009 at 13:17 UTC