Select Code to Download

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

}

DBD::Oracle::st fetchrow_hashref failed: ORA-24345: A Truncation or nu
+ll 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
...
       (LOWER(a.name) = ? OR a.mgmt_ip_addr = ?)

" with ParamValues: :p1='test', :p2='test'] at data.cgi line 720.