The string passed to stored procedure as a parameter is getting truncated.
Crystal Reports Designer 2008
Reproducing the Issue
- Create an Oracle stored procedure with a string parameter
- Try to pass an SQL statement as a stored procedure parameter
There are line breaks in the SQL statement.
Line breaks could not be used in the string parameter
Remove or replace line breaks. SQL statement does not require lines to be separated by line breaks
KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem