This discussion is archived
0 Replies Latest reply: Mar 8, 2013 9:16 AM by 978204 RSS

BUG: Unable to set rule condition using SQL-syntax from the "Rules" tab

978204 Newbie
Currently Being Moderated
I am using SQL Developer version 3.1.06

The "Rules" tab under a CHAIN allows you to change a rule's condition and action.

I have a rule like this:

"step1" SUCCEEDED

I tried to change the rule condition to use the equivalent SQL-syntax:

:"step1".state = 'SUCCEEDED'

It errors with ORA-06550.

However, I can use the following script to change the rule:

begin
DBMS_SCHEDULER.DEFINE_CHAIN_RULE (
chain_name => '"chn_test"',
condition => ':"step1".state=''SUCCEEDED''',
action => 'START "step2"',
rule_name => 'SCHED_RULE$138');
commit;
end;

When I refresh the "Rules" tab, the revised SQL-syntax rule is displayed.

Edited by: 975201 on Mar 8, 2013 9:15 AM