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

Last updated on NOVEMBER 28, 2016

Applies to:

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

Symptoms

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

- 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

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


ERROR:
-----
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
I$SDD_OBJECT_VERSIONS ov
,I$SDD_ENTUIE el
where el.irid=:old.irid
and ov.ivid=el.parent_ivid
and ov.wastebasket='N';

STACK TRACE:
----------------
opiexe -> kxsBindCapture -> kxsCaptureBindValues
.

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