Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: XMLTYPE
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/
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Apr 04 2006 - 13:06:38 CDT