I'm trying to troubleshoot an unexpected value_error exception.
It happens when an scheduled job is run.
But if I run an anonimous block with the same job_action , I don't get that error.
The owner of the job is the same schema.
the job action is something simple like:
Begin
if myuser.my_package.fn_process () then
null;
end if;
end;
If I run the job I get the exception.
BEGIN
DBMS_SCHEDULER.RUN_JOB(job_name => '"MYUSER"."MY_JOB"', USE_CURRENT_SESSION => FALSE);
END;
/
The exception is trapped and sent to a trace table. It happens in a very simple query, involving char to number conversion.
I'm very confused with this.