Skip to Main Content

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!

Debugging a TRIGGER

chuckersFeb 2 2009 — edited Feb 4 2009
I can't figure out how to debug a TRIGGER. If I load it according to the same instructions for loading a PROCEDURE, FUNCTION or PACKAGE (which all work), and then I try to run it in DEBUG, I get the error
Source does not have a runnable target.
In TOAD, when I DEBUG a trigger, I have to set up an anonymous PL/SQL block, with an INSERT, UPDATE or DELETE statement.

I was expecting something similar to pop-up in SQL Developer (similarly to how the pop-up in SQL Developer let's you design an anonymous PL/SQL block before invoking the debugger against a PROC/FUNC/PACKAGE).

Thanks,
--=Chuck
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 4 2009
Added on Feb 2 2009
5 comments
8,619 views