SAP Knowledge Base Article - Preview

2322011 - Error: 'ORA-24374: define not done before fetch or execute and fetch' when refreshing a report in Crystal Reports

Symptom

  • Fail to refresh a report.
  • When adding a SQL Query that uses comments to a report, it fails. 
  • Existing reports used to refresh successfully before updating the Oracle Client.
  • When refreshing or creating a report connected to Oracle in Crystal Reports, that is based on a Command Object with a SQL Query that contains comments on multiple lines, it fails with the error:
          
        "Failed to retreive data from database.
         Details: HY000:[Oracle][ODBC][Ora]ORA-24374: define not done before fetch or execute and fetch
         [Database Vendor Code: 24374 ]"
         
      
        Oracle ODBC Error.png


Read more...

Environment

  • SAP Crystal Reports 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
            
  • SAP Crystal Reports for Enterprise 4.1
  • SAP Crystal Reports for Enterprise 4.2
          
  • Oracle 12c

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.