RE: invalid procedure/trigger

[Richard Ji]

Check the status column of user_objects for procedures etc. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 08, 2003 9:59 PM To: Multiple recipients of list ORACLE-L Subject: invalid procedure/trigger Dear all DBAs,   Is there any way to check whether the procedures or triggers is valid? and if it's not valid, recompile it automatically. Some of the DBAs here always forgot to check procedures/triggers after modify table.   Thanks in advance.