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 procedue.
  • In Crystal Reports, when attempting to create a report off 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 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
      
  • Oracle 10
  • Oracle 11g
  • Oracle 12c

Reproducing the Issue

  1. In Oracle, create a stored procedure.
  2. In Crystal Reports, create a new report off 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 off an Oracle Stored Procedure in Crystal Reports, use one of the following connection:
    • Oracle Native connection; or
    • Oracle ODBC driver

See Also

  • Attached are Stored Procedures support requirements documentation.

Keywords

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

Product

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

Attachments

cr_oracle_stored_procedures.pdf
storproc.pdf