Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Will security Patching /CPU Patching affects using WITH Clause ?

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
This post has been answered by Jonathan Lewis on Mar 31 2021
Jump to Answer

Comments

Jonathan Hult

Can you use a web server (such as Apache or nginx) to front-end WebCenter Content? If so, you can very easily make this happen with URL rewrites (instead of WebUrlMaps).

Jonathan

http://jonathanhult.com

shwetha nayak-Oracle

Thanks for your quick reply Jonathan. But we will not be able to use a web server to front end WebCenter content.

We will be invoking the jsp present in web center content from our application using  WebUrlMaps i.e  http://rws60121rems.us.oracle.com:16203/contentstorage/Ucm Folder1/helloWorld.jsp and we want the jsp to be executed, inorder to refer other files in that folder("UCM Folder1") relative to the jsp. So this is not achievable?

Thanks,

Shwetha

1 - 2

Post Details

Added on Mar 29 2021
#oracle, #pl-sql, #sql
7 comments
197 views