Status of Triggers

[ulicki]

I am working on a proposal for a custom applicaton for a client that involves the uses of triggers. We will allow the user to enable/disable the triggers via a VB application. We also want to display the status of each trigger via the VB application: What SQL statement can we run to obtain this information (i.e. Can it be done)?

Database is ORACLE 8i

Thank you,

Mike

 

[Guest_imported]

select status from dba_triggers where trigger_name = <name> will return 'DISABLED' if the trigger is disabled.

 

[ulicki]

Thanks rc