Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight
 
PerlMonks  

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.

Comment on Get multiple rows in Perl from Oracle
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 (Chancellor) 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?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://814202]
Approved by broomduster
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others chanting in the Monastery: (8)
As of 2014-08-29 00:40 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best computer themed movie is:











    Results (275 votes), past polls