RE: XMLTYPE

From: "Marco Gralike" <Marco.Gralike@xxxxxxx>
To: <Steve.Booth@xxxxxxxxxxxxxxx>, <sjaffarhussain@xxxxxxxxx>, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
Date: Tue, 11 Apr 2006 22:37:31 +0200
 
If you encounter the error as described by M.Godlewski it is also could
practice to disable the recyclebin and/or, if you don't use the
recyclebin feature, to disable it completely via an alter system
statement.
 
 
purge dba_recyclebin;
 
begin
dbms_xmlschema.deleteSchema
('http://www.mydomain.com/myapp/person.xsd',4); -- 4 is the delete
cascade force
end;
/

check via
 
select schema_url from all_xml_schemas;
 
if you cleaned the repository the way you wanted
 
 
Marco
________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of M.Godlewski
Sent: dinsdag 11 april 2006 3:58
To: Steve.Booth@xxxxxxxxxxxxxxx; sjaffarhussain@xxxxxxxxx; oracle-l
Subject: 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."
        --
        //www.freelists.org/webpage/oracle-l
        
        
        --
        //www.freelists.org/webpage/oracle-l
        
        
        


________________________________

How low will we go? Check out Yahoo! Messenger's low PC-to-Phone call
rates.
<http://us.rd.yahoo.com/mail_us/taglines/postman8/*http://us.rd.yahoo.co
m/evt=39663/*http://voice.yahoo.com>
RE: XMLTYPE

Other related posts:
