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

Last updated on JUNE 04, 2024

Applies to:

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

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