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

SAP Knowledge Base Article - Public

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

Symptom

  • 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

Environment

  • Crystal Reports 2008 all patches
  • Oracle 10 g

Reproducing the Issue

  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

 

    Cause

    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"

    Resolution

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

    See Also

    Error message attached below

    Keywords

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

    Product

    Crystal Reports 2008 V1

    Attachments

    ORA-06550.JPG