RE: XMLTYPE

From: Marco Gralike <Marco.Gralike_at_AMIS.nl>
Date: Tue, 4 Apr 2006 20:06:38 +0200
Message-ID: <3FA1E6332C73EB4391F729E4EDB7CED94138B2@amisnt30.AMIS.local>

You could search the XMLDB forum on OTN ---> http://forums.oracle.com/forums/forum.jspa?forumID=34

You could get these errors if you created XMLTYPE (table/column)objects via a registered XML schema in the repository, for instance via

begin
dbms_xmlschema.registerSchema
('http://www.oracle.nl/myschemas/people' , xdbURIType('/public/myschemas/people.xsd').getClob() , TRUE, TRUE, False, TRUE);
end;
/

if correct, the package will create XMLType tables based on the people.xsd schema. If you afterwards force delete the schema from the repository, and you will do it such a way the table created still exist, then you will get the 21700 error.

regards,

Marco Gralike

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of The Human Fly Sent: dinsdag 4 april 2006 16:31
To: oracle-l
Subject: XMLTYPE

Hello list,

One of our developer wanted to insert a record using XMLTYPE, but, got the following error:

ERROR at line 2:

ORA-21700: object does not exist or is marked for delete
ORA-06512: at "SYS.XMLTYPE", line 0
ORA-06512: at line 1

I have searched on google and metalink without any luck. Did any has any advice or solution for this?

--

Best Regards,
Syed Jaffar Hussain
8i,9i & 10g, OCP DBA
Banque Saudi Fransi,
Saudi Arabia
http://jaffardba.blogspot.com/

---

---

"Winners don't do different things. They do things differently."
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Tue Apr 04 2006 - 13:06:38 CDT