1792088 - Crystal Reports hangs while creating the report based on Stored Procedure with parameter

• Unable to run the reports based on stored procedure.
• On parameter screen Crystal Report with stored procedure parameter hangs while creating a report.

• Crystal Reports 2008.
• Oracle 10g R1 (Stored procedure).
• Windows 7

1. Create a Oracle Stored procedure with parameter.
2. Create a Crystal report using the Stored procedure as a datasource.

Note: When the parameter screen is prompted it will not proceed but will just stay static

The parameter in Stored procedure was not defined as 'IN' and so the parameter screen didn't proceed.

Define the parameter in the Stored procedure as 'IN'.

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