Insert Into Xx Select Yy From View Fails Ora-7445 [qcsfgrd] (Doc ID 737625.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.3
This problem can occur on any platform.

Symptoms

-- Problem Statement:
On 10.2.03.0 in Production:
When attempting to run dml statement based on select statement ,the following error occurs:

ERROR:
ORA-07445: exception encountered: core dump [qcsfgrd()+274] [SIGSEGV] [Address 
not mapped to object] [0x000000034] [] []
Current SQL statement for this session:

INSERT INTO WDB.WDB_FREE_TEXT_SEARCH_SUMMARY (SESSION_NO, ENTRY_NO, SOURCE_MNEM,
SOURCE_SUMMARY, ITEM_1, ITEM_2, ITEM_3) SELECT :B5 , :B4 , 'DCS_DOCUMENT_SUMMARY', DOCUMENT_DATA_FILE_SUMMARY, T1.DOC_NO, T2.DOC_FILE_NO, 
T1.DOCUMENT_DATA_FILE_ID FROM DCS.DCS_DOCUMENT T2, DCS.DCS_DOCUMENT_DATA_FILE 
T1 WHERE T1.DOC_NO = T2.DOC_NO AND (T1.CREATE_DATE BETWEEN NVL(:B3 , '01-JAN-
1500') AND NVL(:B2 , SYSDATE) + 1 AND T1.UPDATE_DATE IS NULL OR T1.UPDATE_DATE 
BETWEEN NVL(:B3 , '01-JAN-500') AND NVL(:B2 , SYSDATE) + 1 ) AND CONTAINS (T1.
DOCUMENT_DATA_FILE_SUMMARY, :B1 ) > 0


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