My Oracle Support Banner

Delete In A View With Instead Of Trigger Cause Ora-07445 dump in kxsBindCapture (Doc ID 759469.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Server - Enterprise Edition - Version:
This problem can occur on any platform.


- Getting ORA-07445 and ORA-03113 errors when trying to delete in a view with an instead of

- The error is fired by Oracle Designer. When we try to eliminate a column
from a object in designer, the error happens.

- The error is reproducible when trying to execute the same delete statement
from sqlplus

delete from sdd_entuie
where SDD_ENTUIE.IRID = 397398588002265693361675757822562462
and SDD_ENTUIE.IRID = 397398588002265693361675757822562462;

ORA-07445: exception encountered: core dump [B7FDD8A4] [SIGSEGV] [Address not
mapped to object] [0x0] [] []

- The error in instead of trigger happens in this sql:
select 1
into dummy from
where el.irid=:old.irid
and ov.ivid=el.parent_ivid
and ov.wastebasket='N';

opiexe -> kxsBindCapture -> kxsCaptureBindValues


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

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