$sql='SELECT a.serial_num user_serial FROM device a WHERE (LOWER(a.name) = ? OR a.mgmt_ip_addr = ?)'; $cmd = $dbh->prepare($sql); $cmd->execute('test','test'); while ($row = $cmd->fetchrow_hashref()) { ..... } #### 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.