Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight
 
PerlMonks  

OT: error: fetchrow_hashref failed: ORA-24345

by gopalr (Priest)
on Aug 28, 2013 at 14:57 UTC ( [id://1051292]=perlquestion: print w/replies, xml ) Need Help??

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()) { ..... }
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.

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

      Thanks!!

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: perlquestion [id://1051292]
Approved by rminner
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others browsing the Monastery: (8)
As of 2024-03-28 11:12 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found