ORA-04089: cannot create triggers on objects owned by SYS
712519Aug 19 2009 — edited Aug 19 2009SQL> DECLARE
2 invoiceform VARCHAR2(5000) :=
3 '<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"
4 xmlns:xsd="http://xmlns.oracle.com/xsd">
5 <xs:element name="INVOICEFORM" >
6 <xs:complexType>
7 <xs:sequence>
8 <xs:element name="MailAddressTo">
9 <xs:complexType>
10 <xs:sequence>
11 <xs:element name="Person" type="xs:string"/>
12 <xs:element name="Street" type="xs:string"/>
13 <xs:element name="City" type="xs:string"/>
14 <xs:element name="State" type="xs:string"/>
15 <xs:element name="Zipcode" type="xs:string"/>
16 </xs:sequence>
17 </xs:complexType>
18 </xs:element>
19 </xs:sequence>
20 </xs:complexType>
21 </xs:element>
22 </xs:schema>';
23 BEGIN
24 DBMS_XMLSCHEMA.RegisterSchema('invoiceform.xsd', invoiceform);
25 END;
26 /
DECLARE
*
ERROR at line 1:
ORA-04089: cannot create triggers on objects owned by SYS
ORA-06512: at "XDB.DBMS_XDBZ", line 28
ORA-06512: at line 1
ORA-06512: at "XDB.DBMS_XMLSCHEMA_INT", line 3
ORA-06512: at "XDB.DBMS_XMLSCHEMA", line 14
ORA-06512: at line 24