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.
On 10.2.03.0 in Production:
When attempting to run dml statement based on select statement ,the following error occurs:
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
|This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.|