DBD::Oracle::st fetchrow_hashref warning when fetching multiple records from the table.

Hello,

I am getting a warning like


"DBD::Oracle::st fetchrow_hashref warning: (err=0, errstr=undef,
state=undef) [for Statement "
SELECT item.nreference, item.chold, item.npieces,
item.nweight,
item.ncube, item.cshippername,
item.cwarehouselocation,
item.chazardous_code, item.cdestination,
item.ccomments,
item.nposition, item.ccargodescription,
item.ccargodescription2, item.cshipper_ref,
item.ccommunication_ref
FROM tmp_loadplans loadplan, tmp_loadplan_items item
WHERE loadplan.nreference_code =?
AND loadplan.id = item.tmp_loadplans_id
ORDER BY nposition ASC" with
ParamValues: :p1='NYCWHAM30011258'] at cme231.pl line 369"

when I ran the follwing code.


The code is as follows
-----------------------

$query = qq{
SELECT item.nreference, item.chold, item.npieces,
item.nweight,item.ncube, item.cshippername,
item.cwarehouselocation,item.chazardous_code,
item.cdestination,item.ccomments,
item.nposition, item.ccargodescription,
item.ccargodescription2, item.cshipper_ref,
item.ccommunication_ref
FROM tmp_loadplans loadplan, tmp_loadplan_items item
WHERE loadplan.nreference_code = ?
AND loadplan.id = item.tmp_loadplans_id
};

if ($cReport eq 'NOT_RECEIVED') {
$cReportTitle .= ' (ITEMS NOT RECEIVED)';
$query .= qq( AND item.ccomments = 'NOT RECEIVED' );

}

$query .= qq(ORDER BY nposition ASC);

my $sth = $dbh->prepare( $query );

$sth->execute($cReference)
or die "Can't execute statement: $DBI::errstr";

# Start the report
$rep->start;

# Print the result
# changed the query fetching using hash array
while (my $tmp = $sth->fetchrow_hashref('NAME_lc'))
{
my %hashRef = %{$tmp} if (defined($tmp) && ref($tmp) eq "HASH");

$nReference = $hashRef{nreference};
$cHold = $hashRef{chold};


} undef $tmp;

$sth->finish; undef $sth;


This warning is there in all pages where I am fetching multiple
records.
Our version of DBI : 1.53 and SQL*Plus: Release 3.3.4.0.0.

IS this because of DBI version,or have I done something monstrously
wrong?

.

Relevant Pages

  • Re: How do I suppress warnings when using an Access MDB as a runtime?
    ... The destination computer can have the macro security settings set to Low to ... avoid the three warning messages. ... > warnings you get when you run an update or delete query. ...
    (microsoft.public.access.security)
  • Re: Import data
    ... To turn off the warning message: how do you do the import? ... > I am transfering Txt file into an Access table. ... >>If the filename on the disk is always the same and the ... >>import), then use a DFirst on it for the Delete query, ...
    (microsoft.public.access.macros)
  • Re: Access 2000 Make Table Query Warning Box -- use currentdb.execute
    ... currentdb.execute "SQL or action queryname" ... When this query is run, and before it asks the user for the input, I get a warning message that says that the query is about to replace the table with new data, and is the user ok with that?, yes or no. ... As the database designer, I know to answer yes, and it goes through the function with no issues. ...
    (microsoft.public.access.queries)
  • Re: Import data
    ... I am transfering Txt file into an Access table. ... still receiving the warning message. ... >field in your Deelete query would be something like: ... then use an Append ...
    (microsoft.public.access.macros)
  • RE: getting rid of the "Issuing rollback()" warning
    ... It's an excellent idea for the DBI to fake certain things when it makes ... But transaction control is not one of them. ... getting rid of the "Issuing rollback" warning ... many drivers and database API's can't tell if they are or not. ...
    (perl.dbi.users)