RE: Retrieving data from Oracle

I use fetchrow_hashref with Oracle successfully.

Try specifying the case of the columns (uc or lc depending on preference or
current usage in the program):
	$sth->fetchrow_hashref('NAME_lc')



-----Original Message-----
From: [email protected] [mailto:[email protected]] 
Sent: Tuesday, May 31, 2005 9:36 AM
To: [email protected]
Subject: Retrieving data from Oracle


Sent by mailto:[email protected]
__________________________________________________________

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