Oracle Streams Process with Rule-Based Transformation Aborts With ORA-00600 [kohfrm771] or ORA-07445 [kotgtoid] (Doc ID 738284.1)

Last updated on JUNE 21, 2011

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.1.0.6 - Release: 10.2 to 11.1
Information in this document applies to any platform.

Symptoms

Oracle Streams process with a rule-based transformation defined on it aborts with one of two possible errors:

ORA-600 [kohfrm771]
Call stack:
kohfrem kohfrr kadfre kadadCopy kadadcpy kolo_dispatch koloocp koiocop pevm_MOVOPQ pfrinstr_MOVOPQ pfrrun_no_tool pfrrun

-or-

ORA-7445 [kotgtoid]
Call stack:
kotgtoid kadfre kadadCopy kadadcpy kolo_dispatch koloocp koiocop pevm_MOVOPQ pfrinstr_MOVOPQ pfrrun_no_tool pfrrun plsql_run

The errors occur when a custom rule-based transformation is executed.  The 'current SQL' part of the trace file produced by the ORA-600 or ORA-7445 is similar to:

begin :res := "STRMADMIN"."<TRANSFORMATION_NAME>"(:1); end;

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