SAP Knowledge Base Article - Public

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

Symptom

  • Error: 'Invalid argument type'
  • Error when refreshing a report based off a Stored Procedure in Crystal Reports.
  • When trying to refresh a report based off 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 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
          
  • Oracle 10g
  • Oracle 11g
  • Oracle 12c

Reproducing the Issue

  1. In Crystal Reports, crate a report off an Oracle Stored Procedure containing a input parameter with datatype as '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 found in the SAP Knowledge Base Article 1181947

Keywords

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