gopalr has asked for the wisdom of the Perl Monks concerning the following question:

Hi

I am getting the following error while running fetchrow_hashref below:

$sql='SELECT a.serial_num user_serial FROM device a WHERE (LOWER(a.nam
+e) = ? OR a.mgmt_ip_addr = ?)';
$cmd = $dbh->prepare($sql);
$cmd->execute('test','test');

while ($row = $cmd->fetchrow_hashref())
{
    .....

}

[download]
Error
DBD::Oracle::st fetchrow_hashref failed: ORA-24345: A Truncation or null fetch error occurred (DBD ERROR: ORA-01406 error on field 1 of 1, ora_type 1) for Stat ement " SELECT a.serial_num user_serial FROM device a WHERE (LOWER(a.name) = ? OR a.mgmt_ip_addr = ?) " with ParamValues: :p1='test', :p2='test' at data.cgi line 720. </code>

NOTE:The column SERIAL_NUM has the type VARCHAR2(80) and it has many special characters

Please help me in this regard

Thanks,
Gopal R

Updated: could you please guide me anyone on my queries ?

Replies are listed 'Best First'.
Re: error: fetchrow_hashref failed: ORA-24345
by NetWallah (Canon) on Aug 28, 2013 at 15:13 UTC
    The "ORA-24345: A Truncation or null fetch error occurred" is an ORACLE error - something to do with buffer sizes, or errors in stored procedures.

    FYI - the single quote before "SELECT" appears to be unmatched in your post.

                 My goal ... to kill off the slow brain cells that are holding me back from synergizing my knowledge of vertically integrated mobile platforms in local cloud-based content management system datafication.

[reply]

      Yeah.. There was a typo. but closing single quote is there in my code..

      Thanks!!

[reply]

Back to Seekers of Perl Wisdom