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?

Reply via email to