1 2 Previous Next 24 Replies Latest reply on Mar 24, 2014 6:21 PM by Brian Tkatch

    ORA-00600: internal error code, arguments: [qkebCreateConstantOpn1],

    Brian Tkatch

      Version: 11.2

       

      We have a TABLE in which we added a TRIGGER to capture data from the TABLE when one of two COLUMNs change:

       

      CREATE OR REPLACE TRIGGER MFBME03_Exception_ChangeLog_T1
      AFTER
          DELETE
         OR    UPDATE OF FBME03_EXCEPTION_IND_F, FBME03_EXCEPTION_EFFECTIVE_S
      ON MFBME03_BODY_STYLE
      FOR EACH ROW
      WHEN    (
              NEW.FBME03_EXCEPTION_IND_F <> OLD.FBME03_EXCEPTION_IND_F
              OR    (
                  OLD.FBME03_EXCEPTION_EFFECTIVE_S IS NULL
                 AND    NEW.FBME03_EXCEPTION_EFFECTIVE_S IS NOT NULL
              )
              OR    (
                  OLD.FBME03_EXCEPTION_EFFECTIVE_S IS NOT NULL
                 AND    NEW.FBME03_EXCEPTION_EFFECTIVE_S IS NULL
              )
              OR    NEW.FBME03_EXCEPTION_EFFECTIVE_S <> OLD.FBME03_EXCEPTION_EFFECTIVE_S
          )
      BEGIN
      INSERT
        INTO
          MFBME32_BODY_STYLE_AUDIT_LOG
          (
           FBME03_BDYSTL_K,
           FBME03_BDYSTL_C,
           FBME04_VEHLN_K,
           FBME03_CREATE_S,
           FBME03_CREATE_PROCESS_C,
           FBME03_CREATE_USER_C,
           FBME03_LAST_UPDT_S,
           FBME03_LAST_UPDT_PROCESS_C,
           FBME03_LAST_UPDT_USER_C,
           FBME03_EXCEPTION_IND_F,
           FBME03_EXCEPTION_EFFECTIVE_S,
           FBME32_CREATE_S,
           FBME32_CREATE_PROCESS_C,
           FBME32_CREATE_USER_C
          )
      VALUES
          (
           :OLD.FBME03_BDYSTL_K,
           :OLD.FBME03_BDYSTL_C,
           :OLD.FBME04_VEHLN_K,
           :OLD.FBME03_CREATE_S,
           :OLD.FBME03_CREATE_PROCESS_C,
           :OLD.FBME03_CREATE_USER_C,
           :OLD.FBME03_LAST_UPDT_S,
           :OLD.FBME03_LAST_UPDT_PROCESS_C,
           :OLD.FBME03_LAST_UPDT_USER_C,
           :OLD.FBME03_EXCEPTION_IND_F,
           :OLD.FBME03_EXCEPTION_EFFECTIVE_S,
           SYSTIMESTAMP,
           'E03_UPD_DEL_TRIGGER',
           :NEW.FBME03_LAST_UPDT_USER_C
          );
      END MFBME03_Exception_ChangeLog_T1;
      /
      
      
      

       

      I have a virtual machine running XE (11.2.0.2) in which i ran the DDL generated for our application, with the exception of the target TABLE (E32) where i wrote the DDL manually from the specs.

       

      In XE the following works without error:

       

      UPDATE E03 SET FBME03_EXCEPTION_EFFECTIVE_S = NULL WHERE Rownum = 1;
      
      
      

       

      In Dev,:

       

      UPDATE E03 SET FBME03_EXCEPTION_EFFECTIVE_S = NULL WHERE Rownum = 1
             *
      ERROR at line 1:
      
      ORA-00600: internal error code, arguments: https://community.oracle.com/qkebCreateConstantOpn1, [], [], [], [], [], [], [], [], [], [], []
      
      
      

       

       

      I am told the same error appears in QA (i do not have UPDATE in QA):

      UPDATE "FBMS"."MFBME03_BODY_STYLE" SET FBME03_EXCEPTION_EFFECTIVE_S = TO_TIMESTAMP('28-FEB-14 03.59.42.187000000 PM', 'DD-MON-RR HH.MI.SS.FF AM') WHERE ROWID = 'AAA8PNAAKAAAmM/AAg' AND ORA_ROWSCN = '11006632743845'
      ORA-00600: internal error code, arguments: [qkebCreateConstantOpn1], [], [], [], [], [], [], [], [], [], [], []

       

      UPDATEing FBME03_EXCEPTION_IND_F, with or without FBME03_EXCEPTION_EFFECTIVE_S works fine:

       

      UPDATE E03 SET FBME03_EXCEPTION_IND_F = 'Y' WHERE Rownum = 1;
      UPDATE E03 SET FBME03_EXCEPTION_IND_F = 'Y', FBME03_EXCEPTION_EFFECTIVE_S = SYSDATE WHERE Rownum = 1;
      
      

       

      What can i do to figure out where the issue is?

        1 2 Previous Next