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 later
Oracle Analytics Server - Version 5.5.0 and later
Information in this document applies to any platform.
- 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 :
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"
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