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: sangeeth.vs@masconit.com [mailto:sangeeth.vs@masconit.com] 
Sent: Tuesday, May 31, 2005 9:36 AM
To: oracle-oci@perl.org
Subject: Retrieving data from Oracle


Sent by mailto:oracle-oci-return-160-AMarkiewicz=americantv.com@perl.org
__________________________________________________________

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