ORA-00600: internal error code, arguments: [qkebCreateConstantOpn1] ON UPDATES ON TABLES WITH CONSTRAINTS (Doc ID 1301504.1)

Last updated on AUGUST 06, 2015

Applies to:

Oracle Database - Standard Edition - Version 11.1.0.6 to 11.2.0.3 [Release 11.1 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 08-Aug-2012***

Symptoms

When executing an UPDATE on a table with constraints and triggers, the session fails with ORA-00600: internal error code, arguments: [qkebCreateConstantOpn1]:

E.g.

SQL> CREATE TABLE test AS SELECT 84306 route_id FROM dual;

Table created.

-- add a new column with a NOT NULL constraint
SQL> ALTER TABLE test ADD (route_var_type NUMBER(1,0) DEFAULT 0 NOT NULL);

Table altered.

SQL> CREATE OR REPLACE TRIGGER trg_test
  BEFORE UPDATE ON test
  FOR EACH ROW
  WHEN (NEW.route_var_type != OLD.route_var_type)
  BEGIN
  NULL;
  END;
/

Trigger created.

SQL> UPDATE test SET route_id = 1, route_var_type = 0;

1 row updated.

SQL>
SQL> COMMIT;

Commit complete.

SQL>
SQL> UPDATE test SET route_id = 1;
UPDATE test SET route_id = 1
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [qkebCreateConstantOpn1], [], [],
[], [], [], [], [], [], [], [], []


The call stack is:

... kgeasnmierr <- qkebCreateConstantOpn <- qkexrXformOpn_Col <- qkexrXformOpn <- qkxrXformRwo <- qertbIAllocate <- qertbAllocate <- qknRwsAllocateTree <- qknRwsAllocateTree <- qknRwsAllocateTree <- qknDoRwsAllocate <- qkaTraverseQknDescendents <- qkaTraverseQkn <- qkadrv2Post ...

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms