My Oracle Support Banner

WAM FGA Policy Function Execution Error - ORA-00036: Maximum Number of Recursive SQL Levels (50) Exceeded (Doc ID 1296367.1)

Last updated on MARCH 26, 2019

Applies to:

Oracle Utilities Work and Asset Management - Version 1.9.0 and later
Information in this document applies to any platform.

Symptoms

Policy function execution error when FGA policy is created on the table SA_USER_FGA_RESPONSIBILITY:

SYNERGEN.SDBP_FINE_GRAIN_ACCESS.FINE_GRAIN_GENERIC_RETRIEVAL
ORA-00036: maximum number of recursive SQL levels (50) exceeded

The Trace file gives the following error.

Policy function execution error:

Table/View : SYNERGEN.SA_USER_FGA_RESPONSIBILITY
Policy name: SA_USER_FGA_RESPONSIBILITY
Policy function: SYNERGEN.SDBP_FINE_GRAIN_ACCESS.FINE_GRAIN_GENERIC_RETRIEVAL
ORA-00036: maximum number of recursive SQL levels (50) exceeded

The Drop policy does not execute either. The execution keeps processing without completion.

execute DBMS_RLS.DROP_POLICY('synergen','SA_USER_FGA_RESPONSIBILITY','SA_USER_FGA_RESPONSIBILITY');
commit;

Changes

 

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
References


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