dba_source does contains trigger body
Code:select text from dba_source where name = 'REPCATLOGTRIG'; TEXT -------------------------------------------------------------------------------- TRIGGER system.repcatlogtrig AFTER UPDATE OR DELETE ON system.repcat$_repcatlog BEGIN sys.dbms_alert.signal('repcatlog_alert', ''); END;




Reply With Quote