RE: Retrieving data from Oracle



What does "not working" mean? I use fetchrow_hashreaf all the time and it works very well.

-----------------
Ron Reidy
Lead DBA
Array BioPharma, Inc.


-----Original Message-----
From: PerlDiscuss - Perl Newsgroups and mailing lists
[mailto:sangeeth.vs@xxxxxxxxxxxx]
Sent: Tuesday, May 31, 2005 8:35 AM
To: dbi-users@xxxxxxxx
Subject: 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


This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is intended
to be for the use of the individual or entity named above. If you are not the
intended recipient, please be aware that any disclosure, copying, distribution
or use of the contents of this information is prohibited. Please notify the
sender of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

.



Relevant Pages

  • RE: make problem
    ... What version **exactly** of Oracle ... Perl may be copied only under the terms of either the Artistic License or the ... If you are not the intended recipient, please be aware that any disclosure, ... Please notify the sender ...
    (perl.dbi.users)
  • RE: oracle delete has no effect
    ... did you commit the transaction before you ran your Perl program? ... oracle delete has no effect ... > sender of the delivery error by replying to this message, or notify us by ... intended recipient, please be aware that any disclosure, copying, distribution ...
    (perl.dbi.users)
  • RE: Perl Oracle incompatibility
    ... This is not a Perl issue. ... It was working fine with oracle 8.1.6 and 8.1.7 I guess some configuration ... intended recipient, please be aware that any disclosure, copying, distribution ... sender of the delivery error by replying to this message, or notify us by ...
    (perl.dbi.users)
  • RE: performance problem with dbd oracle
    ... Nothing you ever write in Perl will give you the insert speed you will get with this utility. ... performance problem with dbd oracle ... How can I improve performance when using oracle dbd? ... sender of the delivery error by replying to this message, or notify us by ...
    (perl.dbi.users)
  • Re: ANNOUNCE: DBD:Oracle 1.18
    ... Well a warning in one compiler is better than and error in an other so I ... This might be a problem more with the older oracle OCI in your client. ... perl -Mblib t/26exe_array.t ...
    (perl.dbi.users)