SAP Knowledge Base Article - Preview

1822696 - Poor performance when reporting of an Oracle Stored Procedure in Crystal Reports

Symptom

  • Slow when reporting of an Oracle Store Procedure in Crystal Reports.
  • Crystal Reports status bar shows records are coming from the Stored Procedure in small batches.
  • Native connection to an Oracle Stored Procedure in Crystal Reports takes much more times to retrurn the result than when using an ODBC connection to the same stored procedure.


Read more...

Environment

  • SAP Crystal Reports 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
       
  • Oracle 11g

Product

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

Keywords

CR, Oracle, stored procedure, performance , 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.