ORA-7445 [rwsstd] Fails During Insert With Rownum Pseudocolumn (Doc ID 467413.1)

Last updated on NOVEMBER 28, 2016

Applies to:

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

Symptoms

1. Insert with rownum pseudocolumn fails with ORA-7445 [rwsstd]:

ORA-07445: exception encountered: core dump [rwsstd()+128] [SIGSEGV] [Address not mapped to object] [0x400000000]

2. Example SQL:

INSERT INTO PRF_RSL_LVL (PRLV_SEQ, PRFR_SEQ, RSK_LVL, DTE_LST_CLC)
VALUES (PRLV_SEQ1.NEXTVAL, 545808 , 'A', SYSDATE - MOD(ROWNUM, (SELECT VAL FROM SYS_PAR_NEW WHERE SYS_PAR_TYP = 130)))

3. The call stack trace resembles:

rwsstd qercoStart qersqStart insExecSubQueryIni insExecStmtExecIniEngine insexe

4. An alternate error that can be reported is ORA-7445 [qkaProcessRownum]

With stack trace of:

qkaProcessRownum qkaqkn qkadrv opitca kksFullTypeCheck rpiswu2 kksLoadChild
kxsGetRuntimeLock kksfbc

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