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.

Reply via email to