Re: Oracle 10g - stange internal error

On Jul 1, 8:33 pm, jacquesh <jhu..._at_gmail.com> wrote:
> 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....

Internal errors should be brought to Oracle Support as they usually indicate a bug in Oracle code. Looks like you have a complete reproducible test case that needs to be submitted to Oracle Support with a Service Request. What's Oracle version and platform? Also, try inserting into the table while connected as SYSDBA and see if it will work.

Regards,

   Vladimir M. Zakharychev
   N-Networks, makers of Dynamic PSP(tm)    http://www.dynamicpsp.com Received on Sun Jul 01 2007 - 23:53:41 CDT