Have you looked at DBI?

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

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]

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?