SAP Knowledge Base Article - Public

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

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



    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.

    See Also

    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


    Crystal Reports 2008 V1