My Oracle Support Banner

ERROR: ORA-32036: "unsupported case for inlining of query name in WITH clause" Executing a PLSQL Stored Procedure That is in an INVALID State and Contains a WITH Clause Fails (Doc ID 357776.1)

Last updated on JANUARY 30, 2022

Applies to:

Oracle Data Provider for .NET - Version to
Oracle Provider for OLE DB - Version to
Oracle ODBC Driver - Version to
Microsoft Windows (32-bit)


Executing a PLSQL stored procedure that is in an INVALID state and contains a WITH clause fails with:

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

Executing the PLSQL stored procedure from sqlplus under the same circumstances succeeds. Once the procedure is VALID, it will execute successfully from applications using Oracle Data Access drivers.


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

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