My Oracle Support Banner

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.

Symptoms

  1. Login to Data visualization.
  2. Create a Dataset using the Data connection to the Oracle Database or any database
  3. Choose the option " Enter SQL"
  4. 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.