Oracle 10g - stange internal error

From: jacquesh <jhullu_at_gmail.com>
Date: Sun, 01 Jul 2007 16:33:59 -0000
Message-ID: <1183307639.836816.9630@m36g2000hse.googlegroups.com>

hello, i've a strange problem with this trigger, anyone has an idea about this behaviour

CREATE TABLE FIELDS (

   	ID 		NUMBER,
	NOM 	VARCHAR2(25 CHAR),
	ACL_DEF XMLTYPE,
	COD_HOP VARCHAR2(5 CHAR))
	XMLTYPE ACL_DEF STORE AS OBJECT RELATIONAL
		XMLSCHEMA "http://XXXX/projet/YYY/schema/aclfields.xsd"
		ELEMENT "FIELDS"

/

ALTER TABLE FIELDS ADD constraint VALIDATE_FIELDS CHECK (XMLIsValid(ACL_DEF)=1)
/

• trigger CREATE OR REPLACE TRIGGER TG_INITFIELDS before INSERT ON "FIELDS" FOR each row declare template CLOB ; begin SELECT extract(res, '/Resource/Contents/*').getclobval() INTO template FROM RESOURCE_VIEW WHERE EQUALS_PATH(res,'/home/D47/ xml_templates/xml_templates_fields.xml') > 0 ; IF inserting then IF :NEW."ID" IS NULL then SELECT SQ_FIELDS.NEXTVAL INTO :NEW."ID" FROM dual; SELECT xmltype(template) INTO :NEW."ACL_DEF" FROM dual ; end IF; end IF; end;
  /
  SHOW ERRORS;
  /
  

SQL> INSERT INTO FIELDS VALUES(NULL,'sample',NULL,'00087') ; INSERT INTO FIELDS VALUES(NULL,'sample',NULL,'00087')

                    *

ERREUR a la ligne 1 :
ORA-00600: code d'erreur interne, arguments : [qmxtcUMkProcessImage:invtype],
[], [], [], [], [], [], []
ORA-04088: erreur lors d'execution du declencheur 'D47.TG_INITFIELDS'

thanks for your help.... Received on Sun Jul 01 2007 - 11:33:59 CDT