No trigger body in dba_source

[The problem]

Can see trigger body with dbms_metadata.get_ddl, but can't see in dba_source or dba_triggers. Moreover, the trigger functions well.

[Root Cause]
This is due to a bug in Oracle version 8. For my case , this database was upgraded from 8.0 to 8i to 9i eventually.

To rectify it, just recompile it.


select TRIGGER_BODY from dba_triggers where trigger_name='IVOC_SP_CONTACT3';