SAP Knowledge Base Article - Public

1544128 - Error: "Failed to retrieve data from the database Details: ORA-06550 PLS-00103: Encountered ... " while reporting off an oracle stored procedure universe in crystal designer.

Symptom

While refreshing a crystal report based on Oracle stored procedure universe following error shows up:

"Failed to retrieve data from the database.Details: ORA-06550 PLS-00103: Encountered the symbol "." when expecting one of the following: begin case declare exit for goto if loop mod null pragma raise return select update while with <an identifier> < a double-quoted delimiter-iden     "

Environment

  • Crystal Reports 2008
  • BusinessObjects Enterprise XI R3.1
  • Oracle 10g

Reproducing the Issue

  1. Create a simple universe, using oracle stored procedure
  2. Export the universe
  3. Create new report in Crystal Reports Designer
  4. Select created universe as a data source
  5. Drag drop the fields required in the report.
  6. While refreshing / previewing the report, error shows up

Cause

The issue has been identified and logged under ADAPT01487517

Resolution

Updated instructions on how to use the product have been provided. See below:

 

If you want to get the “owner” (and “qualifier”) in the generated SQL in order to specify it in the execution from CR, you must go to the Universe Designer, Import and Open your SP universe, and Fill the "owner" area from the “rename table” dialog box.
 
In this case, you will get a generated SQL such as:

<SQLSTATEMENT SID="1">
SELECT
  TEST.ID
FROM
(
<Procedure uid="SYSTEMTEST" owner="SYSTEM" name="TEST" type="PROCEDURE">
<Parameter name="CRO" type="RefCursor" mode="InOut"/>
</Procedure>
  )  TEST
</SQLSTATEMENT>

Keywords

ADAPT01487517 , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Bug Filed

Product

Crystal Reports 2008 V1