ORA-7445 [Pfrxca()+89] with User Defined Aggregate Functions (UDAG) Defined in Packages (Doc ID 1328273.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 to 11.2.0.2.0 [Release 9.2 to 11.2]
Information in this document applies to any platform.

Symptoms


ORA-7445 error is received when having used defined aggregate functions (UDAG) linked to a package (the error may vary based on database version).

An example of code that triggers this error:

create or replace PACKAGE RAW_MATH AS
...
FUNCTION sum_aggr (input RAW) RETURN RAW DETERMINISTIC
AGGREGATE USING sum_raw_impl;

END RAW_MATH;
/

On 11.2.0.2 the error has a call stack like below:

pfrxca plsql_run peidxr_run peidxexe kkxdexe kkxmpexe kgmexwi kgmexec ...

Changes

User defined aggregate functions (UDAG) are linked to package used when receiving the error.

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