Click to See Complete Forum and Search --> : Problem with ORACLE JOB
novacd
10-09-2003, 09:04 AM
We are trying to execute a JOB by "DBMS_JOB.RUN(Procedure_ID)" command... and we obtained this error:
ERROR en línea 1:
ORA-12011: la ejecución de 1 trabajos ha fallado
ORA-06512: en "SYS.DBMS_IJOB", línea 405
ORA-06512: en "SYS.DBMS_JOB", línea 267
ORA-06512: en línea 1
Thx in advance.
Regards
tamilselvan
10-09-2003, 10:36 AM
Was this dbms_job ran in Spain?
novacd
10-09-2003, 11:20 AM
Yap in Spain :D
tamilselvan
10-09-2003, 12:03 PM
Does your procedure handle exception?
Did you check up alert log?
Tamil
novacd
10-10-2003, 04:42 AM
We don't have many Administration concepts... can any1 pls tell me how the **** we can check the "famous" Alert Log?
Hellow novacd,
how have you created your job?
I think your problem is like this:
you have created your job
VARIABLE Job_number NUMBER;
BEGIN
DBMS_JOB.SUBMIT(:Job_number,'Procedure_name', ...)
END;
try do it so:
VARIABLE Job_number NUMBER;
EXEC DBMS_JOB.SUBMIT(:Job_number,'Procedure_name', ...);
Is incredible, but it's true.
I had the same problem, and I resolve it so.
jmodic
10-10-2003, 04:57 PM
Originally posted by Coco
Hellow novacd,
how have you created your job?
I think your problem is like this:
you have created your job
VARIABLE Job_number NUMBER;
BEGIN
DBMS_JOB.SUBMIT(:Job_number,'Procedure_name', ...)
END;
try do it so:
VARIABLE Job_number NUMBER;
EXEC DBMS_JOB.SUBMIT(:Job_number,'Procedure_name', ...);
Is incredible, but it's true.
I had the same problem, and I resolve it so.
Has anybody said he is using SQL*Plus to start the job???