CODEWITHSUNDEEP
oracle-databaseplsqloracle11g
Praveen
Praveen

Reputation: 9335

Get all the procedures and functions which are created with compilation error

When creating a procedure/function some are created with compilation errors;

Procedure created.
Warning: Procedure created with compilation errors.
Procedure created.
Procedure created.

How to get the list of procedure/ functions which are created compilation error in Oracle?

Upvotes: 0

Views: 360

Answers (2)

Eng. Samer T
Eng. Samer T

Reputation: 6526

replace owner with your schema

select * from all_objects
where status = 'INVALID'
and owner = 'SCOTT' ;

Upvotes: 2

Lajos Arpad
Lajos Arpad

Reputation: 76508

Query SYS.USER_ERRORS:

select * from SYS.USER_ERRORS where type = 'PROCEDURE'

If there is no guarantee that the user running those is the same user you are logged in with, then query SYS.ALL_ERRORS.

Upvotes: 3

Related Questions