My Oracle Support Banner

While performing OAAM Purging ,few stored procedures failed to compile. (Doc ID 2700455.1)

Last updated on AUGUST 29, 2023

Applies to:

Oracle Adaptive Access Manager - Version 11.1.2.3.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.2.3.0 version, Core DATABASE

When attempting to perform OAAM Purging, the below stored procedures which failed to compile.

SP_VT_ENT_TRX_MAP_PROC
SP_VT_TRX_DATA_PROC
SP_V_FPRINTS_PROC
SP_V_FP_MAP_PROC



ERROR
-----------------------
Failed at "DELETE FROM V_FP_MAP WHERE ROWID=V_MAP_ID(I);"

Compile error "Error(67,37): PL/SQL: ORA-00932: inconsistent datatypes: expected ROWID got NUMBER"



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
Cause
Solution
References


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