Thanks Anand..
Just found out that the sys.order_object_by_dependency is obselete in 8.1.7..even though it exists when a desc is done on it...Hence, to recomiple invalid objects (only procedures and packages) run the utlrp.sql script.
Thanks
Chucks_k




Reply With Quote