Re: Oracle 10g - stange internal error

On 2 juil, 06:53, "Vladimir M. Zakharychev" <vladimir.zakharyc..._at_gmail.com> wrote:
> 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'
i've post new SR to METALINK....

wait for response....

>
> > 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 Mon Jul 02 2007 - 05:30:37 CDT