RE: XMLTYPE
- From: "Marco Gralike" <Marco.Gralike@xxxxxxx>
- To: <sjaffarhussain@xxxxxxxxx>, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 4 Apr 2006 20:06:38 +0200
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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."
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
