Improper SQL in the "DV-Dataset- Enter SQL " will Error with "missing right parenthesis at OCI call OCIStmtExecute"
(Doc ID 2761341.1)
Last updated on MARCH 24, 2021
Applies to:
Oracle Analytics Cloud - Version 105.1.0 and laterOracle Analytics Server - Version 5.5.0 and later
Information in this document applies to any platform.
Symptoms
- Login to Data visualization.
- Create a Dataset using the Data connection to the Oracle Database or any database
- Choose the option " Enter SQL"
- Enter the SQL . The sample SQL is shown below :
Changes
Copy the SQL from the Database format and paste it in the "DV - Data set - Enter SQL" .All the Database SQL formats executed in the Database will not be supported in "DV - Data set - Enter SQL"
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 |