ORA-7445 OCCURS WHEN INSERTING INTO A TABLE WITH DEFAULT VALUE FOR XMLTYPE (Doc ID 272512.1)

Last updated on NOVEMBER 28, 2016

Applies to:

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

Symptoms

ORA-7445 - INSERTION INTO A TABLE WITH DEFAULT VALUE FOR XMLTYPE
This particular Table has XMLType Column with default value defined for it.

When trying to insert record into this table (omitting the XMLType column), the
default value is expected to get inserted, and insert throws ora-3113.



ORA-07445: exception encountered: core dump [0000000101BA1BA4] [SIGSEGV] [Address not mapped to object] [0x700000000] [] []
Current SQL statement for this session:
insert into temp (id) values (:"SYS_B_0")

Stack Trace:

sigacthandler koxsh2gpage qmxtcEvalUMkXML evaopn2 evaopn2 insolev insbrp...

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