Re: Oracle 10g - stange internal error

jacquesh <jhullu_at_gmail.com> wrote in news: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....
>
>

04088, 00000, "error during execution of trigger '%s.%s'" // *Cause: A runtime error occurred during execution of a trigger. // *Action: Check the triggers which were involved in the operation. Received on Sun Jul 01 2007 - 13:02:57 CDT