Hi All,
After applying CPU patching , our queries using WITH clause started failing . Did anyone experienced the sam e? Please share your thoughts.
My query structure is as below
CREATE VIEW test_view
WITH table_1 AS
(select .. from a, b ,c) ,
WITH table_2 AS
(select ... from a, table_1 , c, d e..)
SELECT ....
FROM x , table_1 , table_2...
UNION
SELECT ....
FROM x , table_1 ..
AND NOT EXISTS (select 'x' from table_2);
Error : ORA-32036: unsupported case for inlining of query name in WITH clause
32036. 00000 - "unsupported case for inlining of query name in WITH clause"
*Cause: There is at least one query name which is inlined more than once
because it's definition query is too simple and references another
query name. This is currently unsupported yet.
*Action: remove such query name and retry
Error at Line: 1 Column: 40.
Please note that , error is not related to syntax and not related to data . Same data is working in other instances .. It is related to the usage of table_2.
When I remove the NOT exists condition(last line) , then it works.
Thank You ,
Ashwini