Oracle Solution for Error ora-35587

ORA-35587: (SQLOUT20) The nesting of table functions and SQL commands has exceeded the maximum of number

levels.

What triggered the Error:

The nesting of table functions with the PREDMLCMD token populated with an OLAP DML expression that use the embedded SQL support to access another table function which contains a table functions with the PREDMLCMD token filled in with an OLAP DML expression that uses the embedded SQL support.

What should we do to fix it:

Reduce the level of nesting between table functions and OLAP DML embedded SQL support.