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-21500: internal error

37820Mar 19 2004 — edited Mar 22 2004
Hello,

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"

When I issue a query as

SQL> select value(P) from "countries224_TAB" p
2 /
ERROR:
ORA-21500: internal error code, arguments: [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s]

I am getting ORA-21500 error. Am I missing some thing here?

I appreciate your help. Thanks in advance.

Ram

Comments

mdrake-Oracle
Which release of the database are you using. Are SQL*PLUS and the database running on the same machine. Are you using an earlier release on the client
37820
Hello,

Thanks for your inquiry.

Here is the info

SQL*Plus: Release 9.2.0.1.0 - Production on Fri Mar 19 09:14:38 2004

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production


Ram
mdrake-Oracle
That's the source of your problem. 9.2.0.1.0 is not supported for use with XML DB, even as a client. You need to update the client to 9.2.0.4.0 as well
37820
Hello,

Thanks for your reply. We upgraded our environment to

SQL*Plus: Release 9.2.0.4.0 - Production

Oracle9i Enterprise Edition Release 9.2.0.4.0

The ORA-21500 disappeared. Thanks again. I appreciate your help.

Ram
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 19 2004
Added on Mar 19 2004
#performance-availability, #xml-db
4 comments
415 views