I'm trying to setup a regular job in Oracle using dbms_job. But every time I try to run it, I get the following weird error:
2> new_job integer;
5> dbms_job.submit(new_job, 'begin XMPT_LOAD_PROC; end;',
8> dbms_output.put_line('Job: '||to_char(new_job));
ORA-01858: a non-numeric character was found where a numeric was expected
ORA-06512: at line 5
The proc exists and is valid. If I move the part of line 5 from (new_job, 'be.. to the next line, I get the same error still on line 5. I've made sure the submitting user has exec any proc priv and has been granted exec priv by sys on dbms_job. I've checked that dbms_job is publicly visible via public synonym. Any ideas?