Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked

Get multiple rows in Perl from Oracle

by kalyanrajsista (Scribe)
on Dec 24, 2009 at 09:21 UTC ( #814202=perlquestion: print w/replies, xml ) Need Help??
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.

Replies are listed 'Best First'.
Re: Get multiple rows in Perl from Oracle
by Corion (Pope) on Dec 24, 2009 at 10:10 UTC

    Have you looked at DBI?

Re: Get multiple rows in Perl from Oracle
by marto (Archbishop) on Dec 24, 2009 at 11:21 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;

        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?

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://814202]
Approved by broomduster
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others examining the Monastery: (3)
As of 2018-04-24 05:08 GMT
Find Nodes?
    Voting Booth?