CODEWITHSUNDEEP
sqloracle-database
the_lotus
the_lotus

Reputation: 12748

Finding a list of un-compilable packages

If I make a lot of modifications to tables in Oracle. Is there a way to have a list of packages that don't compile anymore?

I can easely get the list of packages from the list of tables that I changed, but I wonder if it's possible to get everything that isn't compiling.

Upvotes: 1

Views: 232

Answers (1)

rodolfoprado
rodolfoprado

Reputation: 126

this is how you can do that

    select 'alter '||decode(object_type,'PACKAGE BODY','PACKAGE',object_type)||
       ' '||object_name||' compile '||decode(object_type,'PACKAGE BODY','body;',';')
  from user_objects
where status = 'INVALID'

Upvotes: 3

Related Questions