RE: XMLTYPE

When I've seen this error it was the xsd was registered and deleted multiple 
times.
   
  If this is the case, the you need to remove it completely with the force as 
below and then re-register it again cleanly.
   
   
  declare
 unregistered_schema exception;
 PRAGMA EXCEPTION_INIT( unregistered_schema , -31000 );
begin
dbms_xmlschema.deleteschema('contractor_codes.xsd',dbms_xmlschema.DELETE_CASCADE_FORCE);
 exception
  when unregistered_schema then
  null;
end;
/
   
   
  
"Booth.Steve" <Steve.Booth@xxxxxxxxxxxxxxx> wrote:
  Please post the SQL... 

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of The Human Fly
Sent: Tuesday, April 04, 2006 9:31 AM
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




                
---------------------------------
How low will we go? Check out Yahoo! Messenger?s low  PC-to-Phone call rates.

Other related posts: