Last updated on NOVEMBER 28, 2016
Applies to:
Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.3This 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