ORA-32036: unsupported case for inlining of query name in WITH clause tips Oracle Database Tips by Donald BurlesonSeptember 1, 2015

Question: I am gettuing the ORA-32036: unsupported case for inlining of query name in WITH clause.

with
mydata
as (select * from table1)
select * from data, table1
where table1.id = data.id;

The query runs in SQL*Plus, SQL Developer and TOAD but fails when embedded in Java. How do I address the ORA-03236 error?

Answer: The oerr utility shows this for the ORA-32036 error solution:

ORA-32036: unsupported case for inlining of query name in WITH clause

Cause: There is at least one query name which is inlined more than once because it's definition query is too simple and references another query name. This is currently unsupported yet.

Action: remove such query name and retry

In this case, complex queries with nested WITH clauses can throw this error, but ONLY when working SQL is embedded into Java, .Net or C#.

In is a "feature" (bug) in Java, and a common problem when coders try to do too much in SQL and then embed the SQL into Java.

The workaround for the ORA-32026 error is to re-write the SQL WITH clauses using global temporary tables or in-line views.