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 ]"
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.
SAP Knowledge Base Article - Preview