ORA-32036 From Union All Subquery with Collection Table Clause in 12.2 When Calling from Non Owner
(Doc ID 2518322.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 12.2.0.1 and laterInformation in this document applies to any platform.
after upgrade to 12.2c
got
ORA-32036: unsupported case for inlining of query name in WITH clause
Symptoms
- Following Error in 12.2 after upgrade:
ORA-32036: unsupported case for inlining of query name in WITH clause - This works fine in 12.1.0.2.0 and 11g:
WITH ws AS (SELECT * FROM DUAL)
SELECT *
FROM ws,
(WITH ws2
AS (SELECT * FROM TABLE(user1.NUMBER_ARRAY (100))
tab1, user1.V WHERE 1 = 1)
SELECT * FROM ws2
UNION ALL
SELECT * FROM ws2);
- Vis a view refrencing another view in the same user1 schema
- The query succeed when calling from the same views owner user1 but fails
when using different user
Changes
Upgraded to 12.2.
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 |
Changes |
Cause |
Solution |
References |