ORA-7445 occurs under qervwFetch() or qervwRestoreViewBufPtrs() when deleting from View with an INSTEAD OF Trigger

(Doc ID 1674649.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 11.2 to 12.1]
Information in this document applies to any platform.


When running a DELETE on a view having an instead-of trigger, it is possible to get an ORA-7445 under qervwRestoreViewBufPtrs() or qervwFetch() if the view has a column alias that is not referenced.

The issue does not occur on or earlier and is seen after upgrade to or


RDBMS 11.2.04 reports:

ORA-07445: exception encountered: core dump [qervwRestoreViewBufPtrs()+nnnn] [SIGSEGV] [ADDR:0x0] [PC:0x250AABB] [Address not mapped to object] []

 RDBMS / report:

ORA-07445: exception encountered: core dump [qervwFetch()+nnnn] [SIGSEGV] [ADDR:0x0] [PC:0x2CA8DBD] [Address not mapped to object] []



The 'Call Stack' section of the incident trace file confirms the following stack information:

Incident Context Dump

Problem Key: ORA 7445 [qervwRestoreViewBufPtrs()+nnnn]
[05]: qervwRestoreViewBufPtrs [SQL_Execution]<-- Signaling
[06]: qervwFetch [SQL_Execution]
[07]: qerdlFetch [SQL_Execution]
[08]: delexe [DML]
[09]: opiexe []
[10]: kpoal8 []
[11]: opiodr []

Problem Key: ORA 7445 [qervwFetch()+nnnn]
[04]: sslsshandler []<-- Signaling
[05]: __sighandler []
[06]: qervwFetch [SQL_Execution]
[07]: qerdlFetch [SQL_Execution]
[08]: delexe [DML]



The database was upgraded to or

The issue did not occur on earlier releases.


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