SAP Knowledge Base Article - Preview

1980814 - No Oracle stored procedures listed in Crystal Reports, when using an ODBC connection

Symptom

  • Stored procedures missing.
  • No Oracle stored procedures listed in Crystal Reports, when attempting to create a new report via an ODBC connection to Oracle using the CR Oracle ODBC driver. 
  • When creating a new report via an Oracle native connection, it list all the Oracle stored procedures.
      
        
  • Note: Images and data in this SAP Knowledge Base Article is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.


Read more...

Environment

  • SAP Crystal Reports 2016
  • SAP Crystal Reports 2020
  • SAP Crystal Reports 2025
       
  • CR Oracle ODBC Driver 7.0
  • CR Oracle ODBC Driver 7.1.5
  • CR Oracle ODBC Driver 7.1.6
         
  • CR Oracle Wire Protocol ODBC Driver 7.0
  • CR Oracle Wire Protocol ODBC Driver 7.1.5
  • CR Oracle Wire Protocol ODBC Driver 8.0.2

Product

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

Keywords

CR, Oracle SP, StoredProc, Data Direct Oracle ODBC driver, DD ODBC , 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.