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 2016
• SAP Crystal Reports 2020
• SAP Crystal Reports 2025
     
• Oracle 18c
• Oracle 19c 
• Oracle 21c

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