Insert Into ... Select ... From View Fails Ora-7445 [qcsfgrd]
(Doc ID 737625.1)
Last updated on OCTOBER 11, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 10.2.0.1 to 10.2.0.3 [Release 10.2]Information in this document applies to any platform.
This problem can occur on any platform.
Symptoms
On 10.2.0.3 in Production:
When attempting to run DML statement based on select statement, the following error occurs:
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 <Owner>.<Table Name 1> (<Col 1>, <Col 2>, <Col 3>,<Col 4>, <Col 5>, <Col 6>, <Col 7>)
SELECT :B5 , :B4 , '<Col 8>', <Col 9>, T1.<Col 10>, T2.<Col 11>,
T1.<Col 12> FROM <Owner>.<Table Name 2> T2, <Owner>.<Table Name 3> T1 WHERE T1.<Col 10> = T2.<Col 10>
AND (T1.<Col 13> BETWEEN NVL(:B3, '01-JAN-1500') AND NVL(:B2 , SYSDATE) + 1
AND T1.<Col 14> IS NULL OR T1.<Col 14> BETWEEN NVL(:B3 , '01-JAN-500')
AND NVL(:B2 , SYSDATE) + 1) AND CONTAINS (T1.<Col 9>, :B1) > 0
Cause
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
| Symptoms |
| Cause |
| Solution |
| References |