My Oracle Support Banner

Streams Process Getting ORA-7445 [knlqany2lcr()+689] When Using PL/SQL Rule-Based Transformation Function or a DML Handler (Doc ID 745241.1)

Last updated on MAY 11, 2022

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 and later
Information in this document applies to any platform.
This problem can occur on any platform.


Symptoms

You have a Streams setup where either capture or apply process is using a Rule-Based PL/SQL Transformation Function or a DML Handler. So you noticed Streams process failing and aborting with ORA-7745 error with first argument ''[knlqany2lcr()+nnn]", for example:

ORA-07445: exception encountered: core dump [knlqany2lcr()+689] [SIGSEGV] [Address not mapped to object] [0x000000000] [] []

Changes

Added a new Rule-Based PL/SQL Transformation Function or DML Handle to the Streams setup.

Cause

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
Symptoms
Changes
Cause
Solution


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