Using MERGE With APPEND_VALUES In PL/SQL Causes ORA-07445 [klcligprc] (Doc ID 2034927.1)

Last updated on NOVEMBER 04, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 to 12.1.0.1 [Release 11.2 to 12.1]
Information in this document applies to any platform.

Symptoms

Using MERGE with APPEND_VALUES hint fails with error like next in the alert log:

Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x0][PC:0x1EBB360, klcligprc()+18] [flags: 0x0, count: 1]
Errors in file /grdbms/64bit/app/oracle/diag/rdbms/sb23sb/sb23Sb/trace/sb23Sb_ora_12337.trc (incident=2601):
ORA-07445: exception encountered: core dump [klcligprc()+18] [SIGSEGV][ADDR:0x0] [PC:0x1EBB360] [Address not mapped to object] []


The merge sql may look like:

MERGE /*+ APPEND_VALUES */
INTO TEMPLATE T
USING DUAL
ON (UPPER(T.TEMPLATE_ID) = :B2 AND UPPER(T.FORMAT) = :B1)
WHEN MATCHED THEN
  UPDATE SET T.TEMPLATE_NAME = :B6
WHEN NOT MATCHED THEN
  INSERT
    (T.PK_ISN, T.TEMPLATE_ID, T.FORMAT, T.TEMPLATE_NAME)
  VALUES
    (SEQ_TEMPLATE.NEXTVAL, :B3, :B4, :B5);


The call stack in the trace file shows functions like:

... klcligprc qerusFetch updaul updThreePhaseExe upsexe opiexe opipls opiodr rpidrus skgmstack rpiswu2 rpidrv psddr0 psdnal pevm_EXECC pfrinstr_EXECC pfrrun_no_tool pfrrun ...

 

Changes

 No changes were made in the system.

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