Print Thread
My Invalid Objects (type & type body)
#38152 06/03/10 05:07 PM
Joined: Aug 2005
Posts: 65
San Diego, CA
J
jrow Offline OP
Member
OP Offline
Member
J
Joined: Aug 2005
Posts: 65
San Diego, CA
This is a little thing.

An invalid "type" or "type body" does not show up in the browser when the My Invalid Objects option is selected.

They do show as 'INVALID' in the dba_(all_, user_)objects view.


I'm running:

PL/SQL Developer
Version 8.0.3.1510
01.60194 - 1 user license
Windows XP Professional 5.1 Build 2600 (Service Pack 3)

This didn't work in 8.0.0 either.


Re: My Invalid Objects (type & type body)
jrow #38156 06/04/10 09:44 AM
Joined: Aug 1999
Posts: 22,232
Member
Offline
Member
Joined: Aug 1999
Posts: 22,232
This works fine for me. Can you go to Tools > Object Browser Filters and check if the where-clause is defined as follows:

owner = user and status = 'INVALID'

This should of course include the invalid types and type bodies.


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.070s Queries: 14 (0.020s) Memory: 2.4967 MB (Peak: 3.0394 MB) Data Comp: Off Server Time: 2024-06-17 15:12:31 UTC
Valid HTML 5 and Valid CSS