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 OCTOBER 05, 2020
Applies to:Oracle Data Provider for .NET - Version 10.2.0.1.0 to 188.8.131.52.20
Oracle Provider for OLE DB - Version 10.2.0.1.0 to 184.108.40.206.20
Oracle ODBC Driver - Version 10.2.0.1.0 to 220.127.116.11.0
Microsoft Windows (32-bit)
***Checked for relevance on 27-Nov-2012***
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