SAP Knowledge Base Article - Public

1413612 - Crystal Reports Truncates Stored Procedure string parameter

Symptom

 The string passed to stored procedure as a parameter is getting truncated. 

Environment

Crystal Reports Designer 2008

Oracle Database

Reproducing the Issue

  1. Create an Oracle stored procedure with a string parameter
  2. Try to pass an SQL statement as a stored procedure parameter

Cause

There are line breaks in the SQL statement.

Line breaks could not be used in the string parameter

Resolution

Remove or replace line breaks. SQL statement does not require lines to be separated by line breaks

Keywords

KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

SAP Crystal Reports XI