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.