I have cron script that runs fine on a bsd machine, but returns this output on the linux machine.
i have version 1.21 on the linux machine. DBD::Oracle::db do failed: ORA-00000: normal, successful completion (DBD SUCCESS_WITH_INFO: OCIStmtExecute) at /home/scripts/update/recompilestoredprocedures line 33. here is the code: while (my ($oname,$otype) = $select->fetchrow_array) { $sql = "ALTER $otype $oname COMPILE"; unless ( $db->do($sql)) { ## this db statement generates the eror $objectsnotcompiled = $objectsnotcompiled . $oname . ' '; } } Pleas email replies to me directly. thanks.