Home » SQL & PL/SQL » SQL & PL/SQL » dbms_scheduler.create_job() throws error ORA-27362 (Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production)
dbms_scheduler.create_job() throws error ORA-27362 [message #684471] Fri, 11 June 2021 15:01 Go to next message
wtolentino
Messages: 345
Registered: March 2005
Senior Member
our app developers are getting this error when calling the dbms_scheduler.create_job() from within their package procedure:

Error report -
ORA-27362: batch API call completed with errors
ORA-06512: at "SYS.DBMS_ISCHED", line 5609
ORA-06512: at "SYS.DBMS_SCHEDULER", line 4149
ORA-06512: at "CSADEV.IST_SEARCH_EMPLOYER", line 245
ORA-06512: at line 6
27362. 00000 -  "batch API call completed with errors"
*Cause:    Some of the commands submitted to a scheduler batch API call
           could not be successfully carried out because of errors. Other
           commands in the batch may have completed successfully.
*Action:   Check the view [b]SCHEDULER_JOB_ERRORS[/b] to see which commands failed
           and why. Make the appropriate corrections and submit the failed
           commands again.

when we checked there was no SCHEDULER_JOB_ERRORS views. is the SCHEDULER_JOB_ERRORS has been deprecated? also we could not find it when researching on the internet.

thank you,
warren
Re: dbms_scheduler.create_job() throws error ORA-27362 [message #684472 is a reply to message #684471] Fri, 11 June 2021 15:41 Go to previous messageGo to next message
Solomon Yakobson
Messages: 3067
Registered: January 2010
Location: Connecticut, USA
Senior Member
I think it should be scheduler_batch_errors.

SY.
Re: dbms_scheduler.create_job() throws error ORA-27362 [message #684491 is a reply to message #684472] Mon, 14 June 2021 08:29 Go to previous message
wtolentino
Messages: 345
Registered: March 2005
Senior Member
thanks.
Previous Topic: Data masking in oracle
Next Topic: ANSI vs Oracle Join Syntax
Goto Forum:
  


Current Time: Wed Jul 28 14:43:48 CDT 2021