in reply to Is it possible to run SQL select in Oracle and SQL Server to get a large recordset and import it straight into an array, looking to avoid using rownext

G'day newbieperlperson,

That sounds like the selectall_arrayref() method of DBI is what you want.

I suggest you read through the DBI documentation to learn about the various methods, attributes and functions it provides.

-- Ken

  • Comment on Re: Is it possible to run SQL select in Oracle and SQL Server to get a large recordset and import it straight into an array, looking to avoid using rownext

Replies are listed 'Best First'.
Re^2: Is it possible to run SQL select in Oracle and SQL Server to get a large recordset and import it straight into an array, looking to avoid using rownext
by newbieperlperson (Acolyte) on Nov 25, 2013 at 05:27 UTC

    Thank you so much Ken, I will try this out as soon as I get into work, from looking at the method, it looks like it is the solution.

    I sincerely appreciate you taking the time to assist me, I hope one day I can pay it back.

    Regards,

    AJ

[reply]

In Section Seekers of Perl Wisdom