3123343 - Error: 'ORA-00900: invalid SQL statement' when creating a report based on a Command Object in Crystal Reports

• Error: 'ORA-00900: invalid SQL statement'
• Error when attempting to create a report based on a custom SQL Query.
• When creating a report based on Oracle, and adding a Command Object with a custom SQL Query, Crystal Reports fails with the error:           
     
        "Failed to retrieve data from the database.
         Details: ORA-00900: invalid SQL statement
         [Database Vendor Code: 900 ]"
      
         
• Note: Images and data in this SAP Knowledge Base Article is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

• SAP Crystal Reports 2013
• SAP Crystal Reports 2016
• SAP Crystal Reports 2020
     
• Oracle 12c
• Oracle 18c
• Oracle 19c 

1. In Crystal Reports, create a new report based on Oracle.
2. In the Database Expert,  double click on: "Add Command"
3. In "Add Command To Report", type the SQL Query, like:
   
     { SELECT Country 
        FROM Customer
        WHERE Country = 'USA' }
   
   
4. When clicking "OK", it generates the error: 
   
   "ORA-00900: invalid SQL statement"

• It is an Oracle error, indicating an incorrect SQL Query syntax.
• The error occurs because the SQL Query starts and ends with french brackets: { }, which is an incorrect syntax.

• Remove the french brackets at the start and end of the custom SQL Query.
  
  For example: If the SQL Query is:
  
     { SELECT Country 
       FROM Customer
       WHERE Country = 'USA' }
    
  Then the solution is to remove the french brackets: { }, from at the start, and the end of the SQL Query, like:
  
       SELECT Country 
       FROM Customer
       WHERE Country = 'USA' 
   

CR , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020