Error creating Crystal Report using Stored Proc Universe

[Former Member]

Hi,

I have created a stored procedure Universe, using the new feature available in XI R3.

This connects to an Oracle database, executing a PL/SQL procedure returning ref cursor.

I have created a WebI report using this Universe, which works fine and functions as expected.

So there are no problems with either my Oracle stored proc or the Universe.

However, I would like to create a Crystal report (2008) using the same Universe.

I can create the report ok - using the SP Universe.

When I attempt to refresh the data I get an error:

Failed to retrieve data from the database.

Details: ORA-06550: line 1, column 7:

PLS-00103: Encountered the symbol "." when expecting one of the following:

begin case declare etc etc

.................................My Procedure ...................

CREATE OR REPLACE PROCEDURE BIADM.Bo_Test_Report_R

(Deposit_Cursor IN OUT SYS_REFCURSOR)

IS

BEGIN

OPEN Deposit_Cursor FOR

SELECT DISTINCT foracid "A/C"

, acct_name "A/C Name", acct_opn_date "OP/Date", schm_code "SchmCode"

FROM gam@finrpt

WHERE acct_cls_flg ='N'

AND foracid ='2252020145001';

--AND cust_id ='CB2020145'

END Bo_Test_Report_R;

...............................

Please Give me solution as early as possible.

Masud Iqubal

[former_member11696]

Moved to Universe Design forum.