SAP Knowledge Base Article - Public

2169139 - Oracle OLE DB Provider support for Stored Procedures in Crystal Reports

Symptom

  • Error: PLS 00306 wrong number of types or arguments.
  • Unable to create a report off an Oracle Stored Procedure.
  • In Crystal Reports, when attempting to create a report on an Oracle Stored Procedure using an OLE DB Provider, it fails with an error like:
     
       " Description : ORA -06550 Line 1 Column 7
         PLS 00306 wrong number of types or arguments to the <Strored Procedure Name> "

Environment

  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
  • SAP Crystal Reports 2020
      
  • Oracle 11g
  • Oracle 12c
  • Oracle 18c
  • Oracle 19c

Reproducing the Issue

  1. In Oracle, create a stored procedure.
      
  2. In Crystal Reports, create a new report based on an Oracle Stored Procedure using the Oracle OLE DB Provider.
       
    It fails with an error like: "PLS 00306 wrong number of types or arguments to the <Strored Procedure Name> "

Cause

  • Stored Procedures are not supported when connecting using the Oracle OLE DB Provider.
  • This is the OLE DB Provider limitation, not the Crystal Reports limitation.

Resolution

  • To report on an Oracle Stored Procedure in Crystal Reports, use one of the following connection:
    • Oracle Native connection; or
    • Oracle ODBC driver

See Also

  • For Oracle Stored Procedures support requirements, see the SAP Knowledge Base Article 1181947 

Keywords

ORA, stproc, SP, failed , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020

Attachments

cr_oracle_stored_procedures.pdf
storproc.pdf