Scheduler Chain script generated by Toad is missing some quotes. The DDL script is wrong, invalid or incomplete.
The word SUCCEEDED has 2 single quotes on left side and 3 single quotes on right side, but the script created by TOAD has 1 single quote on left side and 2 single quotes on right side. ('SUCCEEDED'' instead of ''SUCCEEDED''')
The script below is a sample (valid or correct) script. The issue will show once you create this object in the database and view it in Schema Browser | Sched. Chains | Script tab.
BEGIN
SYS.DBMS_SCHEDULER.CREATE_CHAIN (
chain_name => 'CHAIN_2'
,rule_set_name => NULL
,evaluation_interval => NULL
,comments => NULL);
SYS.DBMS_SCHEDULER.DEFINE_CHAIN_STEP (
chain_name => 'CHAIN_2'
,step_name => 'STEP_A'
,program_name => 'SCHED_PROG_A');
SYS.DBMS_SCHEDULER.DEFINE_CHAIN_RULE (
chain_name => 'CHAIN_2'
,condition => ':STEP_A.state = ''SUCCEEDED'''
,action => 'END '
,rule_name => 'END_OF_CHAIN2'
,comments => NULL);
SYS.DBMS_SCHEDULER.DEFINE_CHAIN_RULE (
chain_name => 'CHAIN_2'
,condition => 'TRUE'
,action => 'START STEP_A'
,rule_name => 'START_OF_CHAIN2'
,comments => NULL);
END;
/
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center