Retrieving data from Oracle

Hi,

I'm migrating a perl application in postgres to Oracle. Here, the data is
being retrieved as below.

while ($row = $sth->fetchrow_hashref()) {
push (@list,$row);
}

It looks like fetchrow_hashref() is not working with Oracle. But I'm able
to retrieve the data through fetchrow_array. Any idea why
fetchrow_hashref() is not working? Is there any other alternative for
fetchrow_hashref()? How do I accomplish the above with any other fetch
methods?

Thanks in advance.

Sangeeth

.

Relevant Pages

  • Re: the 20% rule
    ... The fastest way to retrieve rows from a table is to access the row ... query that you use often, ... configuration variables, such as shared global memory areas, cached ... With Oracle, it is generally best to rely on tools like explain ...
    (comp.databases.theory)
  • Re: How to get meta data info in ADO.NET
    ... Database Schema from MS SQL Server and Oracle. ... can successfully retrieve all the tables and columns from the database. ... How can i identify which columns are primary key or foreign key? ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Oracle adapter issue in BizTalk
    ... And are you using BizTalk 2006 Server with Oracle ... How can I retrieve multiple records using oracle adapter? ... My procedure in the package returns ref courser. ... I want to retrieve multiples record from table using procedure. ...
    (microsoft.public.biztalk.general)
  • Re: Capturing returned ODBC error message using form_Error
    ... > I have written an application with an Access front end to an Oracle ... > All security and data validation is in the Oracle database, ... Is there any way I can retrieve this message during ...
    (microsoft.public.access.externaldata)
  • Re: odbc>=8.1 and the broken euro symbol
    ... testserver via sys.props$: ... in prod 10.1 i cannot retrieve that value via v$parameter ... i havent worked with oracle since 5yrs and am only supposed to ...
    (comp.databases.oracle.misc)