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 03, 2023
Applies to:
Oracle Data Provider for .NET - Version 10.2.0.1.0 to 11.1.0.6.20Oracle 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)
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
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
| Symptoms |
| Cause |
| Solution |
| References |