Home » SQL & PL/SQL » SQL & PL/SQL » regarding undefined object type
regarding undefined object type [message #244364] Tue, 12 June 2007 08:17 Go to next message
rolex.mp
Messages: 161
Registered: February 2007
Senior Member
When i queried dba_objects I found a few objects which fall under the category of undefined objects .

What do these objects mean ?
Re: regarding undefined object type [message #244376 is a reply to message #244364] Tue, 12 June 2007 09:04 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
2 kinds:
- Internal stuff, don't mind
- Objects not handled by the view definition (that is view definition bug)

Regards
Michel
Re: regarding undefined object type [message #244390 is a reply to message #244364] Tue, 12 June 2007 10:12 Go to previous messageGo to next message
rolex.mp
Messages: 161
Registered: February 2007
Senior Member
Does internal stuff refer to oracle internal error ?

What does view definition bug mean ?
Re: regarding undefined object type [message #244400 is a reply to message #244390] Tue, 12 June 2007 11:19 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
A view has a definition that you can see in dba_views.
This view definition is based upon some tables (or other views).
As this is SQL and SQL is code and each code can have bug, a view definition can have a bug.

Is this case, if you look at the view definition, the bug is missing cases in the "decode".

Regards
Michel
Previous Topic: Replace Leading Spaces
Next Topic: Use of Oracle Cursors?
Goto Forum:
  


Current Time: Thu Dec 08 23:55:26 CST 2016

Total time taken to generate the page: 0.11713 seconds