GO DIRECTLY TO
My Oracle Support Community
Oracle Technology Network
Application Development in PL/SQL
SQL Developer (Not for general SQL/PLSQL questions)
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Mar 8, 2013 9:16 AM by 978204
BUG: Unable to set rule condition using SQL-syntax from the "Rules" tab
Mar 8, 2013 9:16 AM
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:
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:
chain_name => '"chn_test"',
condition => ':"step1".state=''SUCCEEDED''',
action => 'START "step2"',
rule_name => 'SCHED_RULE$138');
When I refresh the "Rules" tab, the revised SQL-syntax rule is displayed.
Edited by: 975201 on Mar 8, 2013 9:15 AM
Track in Communications