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
- In Oracle, create a stored procedure.
- 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 |