Re: Where is the executable code of a trigger stored in the DBMS?

The source code for triggers is stored in source$ Before version 7.3, triggers were not stored in compiled form, so for performance reasons, people used to write the code in procedures and call them from triggers.
But now like other code objects, the compiled code of triggers is stored in the data dictionary as well. (IDL$_ tables)

For more info read these notes

http://asktom.oracle.com/pls/ask/f?p=4950:8:2107683544603824394::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:571023051648

You can trace the create trigger statement to see all the recursive SQL generated on the IDL and other internal tables. regards
srivenu Received on Sat Nov 12 2005 - 17:42:45 CST