My Oracle Support Banner

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:


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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.