SAP Knowledge Base Article - Public

2238875 - Connecting to Oracle from Crystal Reports

Symptom

  • Error when connecting to Oracle.
  • Issue reporting off Oracle in Crystal Reports.
  • Problems connecting to Oracle from Crystal Reports.

Environment

  • SAP Crystal Reports 2016
  • SAP Crystal Reports 2020
  • SAP Crystal Reports 2025
       
  • SAP Crystal Reports for Enterprise 4.2
  • SAP Crystal Reports for Enterprise 4.3
       
  • Oracle 12c
  • Oracle 18c
  • Oracle 19c
  • Oracle 21c

Resolution

  • Below is a list of common issues connecting to Oracle from:
    • Crystal Reports, and
    • Crystal Reports for Enterprise
           
                     
  • For Crystal Reports
                
  • Generic Connectivity and Configuration:
        
    • 2384904 - Does Crystal Reports supports Oracle 18c, 19c and 21c?        
    • 1752459 - Oracle Server connection missing in Crystal Reports   
    • 1337708 - Crystal Reports support of 64 bit Operating Systems   
    • 1217820 - Registry settings to configure ODBC database drivers and SQL Syntax joins   
    • 1432328 - Schema tables do not appear in the Database Expert when connecting to Oracle 11g through ODBC driver  
    • 1850017 - Error: 'ORA-12505' when creating a JDBC connection based on Oracle database    
    • 1698249 - Error: 'Failed to open the connection' when refreshing a report based off a universe using Oracle JDBC   
    • 1688743 - Error: 'Failed to load database information', when scheduling or viewing reports based off Oracle   
    • 1197846 - Error: 'Database Connector Error:'HY000:[Oracle][ODBC][Ora]ORA-01456: May not perform insert/delete/update'  
               
        
  • Oracle Stored Procedures:
         
    • 1181947 - Oracle Stored Procedures Requirements for Crystal Reports  
    • 1822696 - Poor performance when reporting off an Oracle Stored Procedure in Crystal Reports  
    • 2169139 - Oracle OLE DB Provider support for Stored Procedures in Crystal Reports (ORA -06550)  
    • 1569938 - No data or incomplete data set, when reporting off an Oracle View, Stored Procedure, or Command Object  
    • 1574554 - Error: 'Invalid argument type' when refreshing a report based off an Oracle Stored Procedure
    • 1569990 - Error: 'Failed to Retrieve Data from Database ORA-06550' when adding an Oracle Stored Procedure   
    • 2140646 - Error: 'Failed to retrieve data from the database. ORA-00942' when connecting to an Oracle 12c Stored Procedure 
    • 1544128 - Error: 'Failed to retrieve data from database. ORA-06550 PLS-00103: Encountered ... " while reporting off a Universe based off an Oracle Stored Procedure     
         
                  
  • Incorrect behavior:
        
    • 1680608 - Crystal Reports against Oracle database takes a long time to refresh         
    • 2005553 - Crystal Reports does not display Oracle Unicode data correctly     
    • 1206647 - Does Crystal Reports support Oracle TIMESTAMP data type fields?     
    • 1205489 - Mixed or incorrect data in Crystal reports that use Oracle Long fields   
    • 1843192 - Report based on an Oracle View returns wrong data   
    • 1839148 - Crystal Reports based on Oracle takes a long time to execute     
    • 1415792 - Crystal Reports return incorrect result when reporting against Oracle    
    • 1906004 - Error: 'Oracle tnsnames entry not found', when viewing a report based on Universe in SAP BI LaunchPad  
    • 1626943 - Error: 'ORA-00942 Table or View does not exist' on a report based on Business Views based on Oracle
          
        
  • Known Defects: 
       
    • 1339862  - Reports slow to render with multiple subreports and Native Oracle driver   
    • 1702608 - Wildcard character not working for Oracle database in Crystal Reports    
    • 1202730  - Oracle database connectivity issues when installing Crystal Reports 2008 on a 64-bit Windows platform
               
                
  • How to:
      
    • 2017430 - How to add Oracle hint in Crystal Reports?  
    • 1204190 - Size limitation of an Oracle CLOB field in Crystal Reports
    • 1517132 - Timestamp is included in the input parameter inspite of the parameter being Date type in Crystal Report based on Oracle stored Procedure.
          
                  
  • For Crystal Reports for Enterprise
          
    • 2147860 - Search in Crystal Reports for Enterprise LOV prompt is case-sensitive for reports connected to Oracle
    • 2166471 - Error: 'The data source 'Oracle 12' is not suported' when attempting to connect to an Oracle 12c  
    • 2169341 - Error: 'Java Class not found in classpath : oracle.jdbc.OracleDriver' when creating a universe connection using an Oracle JDBC driver  

Keywords

KBA , crystal reports , connectivity , BI-RA-CR , Crystal Reports designer or Business View Manager , How To

Product

SAP Crystal Reports 2016 ; SAP Crystal Reports 2020 ; SAP Crystal Reports 2025