My Oracle Support Banner

Receiving ORA-24102: Invalid Prefix For Generate_job_name (Doc ID 2494677.1)

Last updated on JULY 02, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 18.1.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Getting below Error while running jobs in DBMS_SCHEDULER.


ORA-24102: invalid prefix for generate_job_name

Receiving errorstack similar to below:

STACK TRACE/FILE Information
============================
*** 2018-12-19T09:11:37.955740+00:00 (CDB$ROOT(1))
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x0, level=3,mask=0x0)
----- Error Stack Dump -----

ORA-24102: invalid prefix for generate_job_name
----- Current SQL Statement for this session (sql_id=8swp72nm400p5) -----
BEGIN dbms_scheduler.run_chain(chain_name  => 'CHN_CAB', START_STEPS =>NULL); END;
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
0x7c6cfdc8        79  package body SYS.DBMS_SYS_ERROR.RAISE_SYSTEM_ERROR
0x61c2b290      3614  package body SYS.DBMS_SCHEDULER.GENERATE_JOB_NAME
0x61f448c0      2787  package body SYS.DBMS_ISCHED.RUN_CHAIN
0x61c2b290      2256  package body SYS.DBMS_SCHEDULER.RUN_CHAIN
0x7c46f830         1  anonymous block

----- Call Stack Trace -----

     ksedst1 <- ksedst <- dbkedDefDump <- ksedmp <- dbkdaKsdActDriver
        <- dbgdaExecuteAction <- dbgdaRunAction <- dbgdRunActions <-dbgdProcessEventAct <- ions
         <- dbgdChkEventKgErr <- dbkdChkEventRdbmsEr <- dbgePostErrorKGE <-1140 <- dbkePostKGE_kgsf
          <- kgeade <- kgerelv <- kserecl0 <- kkxerse <- pevm_icd_call_commo<- pfrinstr_ICAL <- pfrrun_no_tool

          <- pfrrun <- plsql_run <-peicnt <- kkxexe <- opiexe <- kpoal8 <- opiodr <- ttcpip
             <- opitsk <- opiino <- opiodr <- opidrv <- sou2o  <- opimai_real <- ssthrdmain <- main <- libc_start_main <-start



========== FRAME [17] (kkxerse()+358 -> kserecl0()) ==========
defined by frame pointers 0x7ffc47f5ede0  and 0x7ffc47f5ed20
CALL TYPE: call   ERROR SIGNALED: yes   COMPONENT: PROGINT_PLSQL

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.