Compile invalid objects not working on 10.0.5.1710

[Cyberdyne]

Good day, I searched the forum to see if this was reported and it appears it was but it was an old thread so I decided to make a new one instead of necroving an old one.

Anyway, we have an 100 user license for PL/SQL Developer and I noticed the compile invalid objects button works but it says there are no invalid objects in the database (but there are). I can run a query as SYS / SYSDBA

select * from dba_objects where status 'VALID'

and it does produce many results. Is there a fix for this? I know I can work around it but it was nice to have where it worked in the previous version.

My Oracle client is a 32bit 11gR1 if that matters.

I login to the database in question as SYS/SYSDBA and the same thing happens.

Regards.

 

[Hilarion]

The list of objects reported in that window is affected by the object browser filter option selected, so check what happens when you choose a filter that matches the objects you found by your select statement (or a filter that returns all objects).

 

[Cyberdyne]

Thank you Hilarion for your post. Although just selecting a filter that returns all objects wasn't enough I actually had to use a where clause so it would return results. So I just made my own filter "All invalid objects" with a where clause as follows:

owner is not null and
status 'VALID'

This now returns the results I expected. Thanks for steering me into the right direction.

Cheers.