Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unable to see the WHEN clause for a trigger.

BarnesyOct 28 2012 — edited Jul 3 2013
I have an existing trigger that I want to add a WHEN clause too. When I add the WHEN clause and compile the trigger everything compiles. However, the WHEN clause is not visible when trying to view the trigger either through the table and trigger tab or by going the the triggers node. Also the triggers displayed under the table tab no longer display the full trigger code only the pl/sql block. This appears to be a problem in this version of SQL developer (3.2.10.09 Build 09.57) I can see the complete trigger code in an older version of SQL developer (3.1.0.7).
Database version : 11.2

The when clause is visible when you query the user_triggers table.

Can someone confirm this is a problem or is there a setting I need to change??
Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 31 2013
Added on Oct 28 2012
#11g, #error, #sql-developer, #trigger
10 comments
2,041 views