Create TYPE Failing With "ORA-00600: Internal Error Code, Arguments: [qcsrwae1]" Error (Doc ID 2850964.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

This is very similar if not the same issue found in Bug 31720455, with its fixes available starting with 19.14.

This can be reproduced with:

CREATE or replace TYPE xxx_message_typ AS OBJECT (   xxx_message    
VARCHAR2(20) );
/
set serveroutput on
DECLARE
  ZZZ xxx_message_typ;
  output varchar2(100);
BEGIN
  ZZZ := xxx_message_typ('KUKUKUKUKU');
  select json_object( ZZZ ) into output from dual;
DBMS_OUTPUT.PUT_LINE(output); -- display details
END;
/

----------

----------

DDE: Problem Key 'ORA 600 [qcsrwae1]' was flood controlled (0x6) (incident: 35784697)
ORA-00600: internal error code, arguments: [qcsrwae1], [20], [14], [1], [], [], [], [], [], [], [], []

Error:  ORA-00600 [qcsrwae1] [19] [14] [1]

Error Stack: ORA-600[qcsrwae1]
Main Stack:  
 qcsrwae <- qjsnSemAnalyze <- koksSvrNameres_ProcOpt <- qcsoPostNameres_ProcOpn
  <- qcsoProcessOpt <- qcsAnalyzeExpr_PostNameRes <- qcsAnalyzeExpr
   <- qcsProcessOpnsInQbc <- qcspqbDescendents <- qcspqb <- qcsdrv <- qcitrans <- qcisem
    <- ph2csql_analyze <- ph2stm <- ph2sms <- ph2blo <- ph2obl <- ph2sbo <- ph2itm <- ph2its <- ph2blo
     <- ph2obl <- ph2uni <- ph2dr2 <- ph2drv <- phpsem <- phpcmp <- pcicmp0 <- kkxcmp0 <- rpiswu2
      <- kkxcmp <- koktcrt <- opiexe <- opiosq0 <- kpooprx <- kpoal8 <- opiodr <- ttcpip <- opitsk
       <- opiino <- opiodr <- opidrv <- sou2o <- opimai_real <- ssthrdmain <- main

Changes

Issue started after patching the databases to current version 19.14.0.0.220118.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.