Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORA-04043: object XXXXX does not exist

37820Mar 22 2004 — edited Mar 31 2004
ORA-21500: internal error Mar 19, 2004 9:18 AM
Reply

Hello,

Here is our environment
SQL*Plus: Release 9.2.0.4.0 - Production

Oracle9i Enterprise Edition Release 9.2.0.4.0

We registered a schema in XML DB. The object table "countries224_TAB" was created.

SQL> desc "countries224_TAB"
Name Null?
Type
------------------------------------------------------------------------ ------
-- -------------------------------------------------
TABLE of SYS.XMLTYPE(XMLSchema "countries" Element "countries") STORAGE Object-r
elational TYPE "CountriesType222_T"


SQL> desc "CountriesType222_T"
"CountriesType222_T" is NOT FINAL
Name Null? Type
------------------------------------------------------------------------ -------- ------------------------
SYS_XDBPD$ XDB.XDB$RAW_LIST_T
country country223_COLL

SQL> desc "country223_COLL"
"country223_COLL" VARRAY(2147483647) OF CountryType221_T
ERROR:
ORA-04043: object CountryType221_T does not exist

SQL> desc "CountryType221_T"
"CountryType221_T" is NOT FINAL
Name Null? Type
------------------------------------------------------------------------ -------- --------------------------------------
SYS_XDBPD$ XDB.XDB$RAW_LIST_T
countryCode VARCHAR2(3)
countryName VARCHAR2(4000)


Why am I getting ORA-04043: object CountryType221_T does not exist ?

But desc "CountryType221_T" showed result.

Am I missing some thing here?

I appreciate your help. Thanks in advance.

Ram

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 28 2004
Added on Mar 22 2004
#performance-availability, #xml-db
6 comments
1,044 views