Toad World® Forums

Oracle scheduler chain script issue

TOAD is not generating the correct script for Oracle scheduler chain. This is the complete code to create a Oracle 11g Scheduler chain.

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;
/

In my script, 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’’’)

This is fixed for the next beta. Thank you for the sample script, I appreciate it.