Re: Table containing names of stored procs, triggers?

Have a look in all_source or all_objects or, if you have dba rights, dba_objects and dba_source.
Frank

robsoft wrote in message ...
>Can somebody tell me how I would go about finding out what triggers and
>stored procedures/functions are installed on a given database?
>
>I'm writing some code that needs to check that various updates to the
>database have been made before it can be run - so I want to be able to
>verify, for instance, that trigger 'AddStockToTotal' is installed, and
>that for instance function 'ApplyHalfLifeToStock' is installed.
>
>I'm sure that there must be a system table that contains a list of names
>(and maybe the definitions?) for this kind of thing - what's it called?
>
>Any help would be gratefully received!
>
>rob_at_xxrobsoft.compulink.co.uk
>(remove the xx for my email address)
Received on Fri Dec 12 1997 - 00:00:00 CET