1569990 - Error: "Failed to Retrieve Data from Database ORA-06550" when adding Oracle Stored Procedure in Crystal Reports

• Error: "Failed to Retrieve Data from Database ORA-06550"
• Error: "Test_Procedure must be declared" when adding an Oracle Stored Procedure named Test_Procedure in the report

• Crystal Reports 2008 all patches
• Oracle 10 g

1. Create a Schema in Oracle and name it "SAP"
2. Create a Stored Procedure named "Test_Procedure" in Schema "SAP"
3. Create a Package in Schema "SAP" and name it "SAP"
4.  Launch Crystal Reports Designer and connect to the Schema "SAP"
5.  Try to add the Stored Procedure "Test_Procedure" in the Crystal Report
6.  Error: "Failed to Retrieve Data from Database ORA-06550" would pop up

Crystal report designer appends the schema name as prefix in the query and this is the default behavior of CR Designer. In the scenario where a package with same name as schema name exists in the schema, the query generated would fail. This happens because, Crystal tries to search for the stored procedure inside the package and gives the error "Procedure must be declared"

Change the Package name to make it different from the Schema name.

Error message attached below

ORA-06550, Oracle Stored Procedure, Procedure Must be declared, Crystal Reports, Oracle Stored Procedure , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem