Re: how to correct invalid objects

Dear Ms. Mala,

If any objects are invalid you need to do the following:

SQL> alter package <Owner>.<object name> compile;

If the invalid object is a package body do the following:

SQL> alter package <Owner>.<object name> compile body;

(You will have to adjust the statements above for invalid objects that are triggers or views instead of packages of course...)

Hope this helps.

Regards, Received on Fri Nov 03 2000 - 00:45:13 CST