SAP Knowledge Base Article - Public

1574554 - Error: 'Invalid argument type', when refreshing a report based on an Oracle Stored Procedure in Crystal Reports

Symptom

  • Error: 'Invalid argument type'
  • Error when refreshing a report based on a Stored Procedure in Crystal Reports.
  • When trying to refresh a report based on an Oracle Stored Procedure containing a input parameter with a datatype as: 'Object', it generates the following error in Crystal Reports: "Invalid argument type"

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 Crystal Reports, create a report based on an Oracle Stored Procedure containing a input parameter with data type: 'Object'.
  2. Refresh the report.
  3. Enter the parameter values for the Oracle Object.
    It will generate the error:  "Invalid argument type"

Cause

  • Crystal Reports does not support a user defined Object datatype created in Oracle. It will treats it as a default String datatype.

Resolution

  • Modify the Oracle Stored Procedure to meet the Oracle Stored Procedure Requirements for use in Crystal Reports as found in the SAP Knowledge Base Article 1181947

Keywords

Crystal Report,Oracle Stored Procedure,Object Datatype. , 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