Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
With not working in View in Physical Layer

Hi All,
I have a View in the Physical Layer which starts with "With" and the report is throwing error the below error:
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 17001] Oracle Error code: 32034, message: ORA-32034: unsupported use of WITH clause at OCI call OCIStmtExecute. [nQSError: 17010] SQL statement preparation failed. (HY000)
Do i have to enable any database feature for the "With" to be accepted in my View. Please suggest.
Thanks & Regards,
Kalpana
Answers
-
Hi,
As OBIEE already generate queries using WITH when the code of your view will be injected into the generated query it makes an invalid SQL.
What OBIEE does is it takes the code of your view and put it in its own query as a subquery, so it's why the WITH doesn't work.
I don't really think it can works because of the way OBIEE use the code of the VIEW when it generated queries, not sure if there is a setting to change that aspect.
0 -
Hi Gianni Ceresa,
Thank you. I changed my Query now without the with clause.
0