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 JULY 05, 2017

Applies to:

Oracle Data Provider for .NET - Version 10.2.0.1.0 to 11.1.0.6.20
Oracle Provider for OLE DB - Version 10.2.0.1.0 to 11.1.0.6.20
Oracle ODBC Driver - Version 10.2.0.1.0 to 11.1.0.6.0
Microsoft Windows (32-bit)
***Checked for relevance on 27-Nov-2012***


Symptoms

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.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms