Thanks for the question, Naveen.
Asked: May 11, 2023 - 2:30 pm UTC
Last updated: May 12, 2023 - 1:57 pm UTC
Version: R19
Viewed 100+ times
You Asked
I have to find list of all uncomplied objects in my database including ETL procedure, Packages, functions etc. How can I find it.
and Chris said...
I'm not sure what you're referring to by "uncompiled". If you want to find PL/SQL objects that are not valid, check the status in the *OBJECTS views:
create or replace function invalid_func ( p int )
return int as
retval int;
begin
return junk;
end invalid_func;
/
LINE/COL ERROR
--------- -------------------------------------------------------------
5/3 PL/SQL: Statement ignored
5/10 PLS-00201: identifier 'JUNK' must be declared
select object_name, status
from user_objects
where status <> 'VALID';
OBJECT_NAME STATUS
INVALID_FUNC INVALID