Skip to Content
0
Former Member
Jul 18, 2013 at 09:53 AM

Crystal Reports 10 accessing Stored Procedure from oracle.

48 Views

Hello I am trying to access a stored procedure in Oracle from crystal report 10. But i face a error. Can anybody help me on this? I am trying to use OLE DB to access the stored procedure in the oracle. I can see the stored procedure in the crystal report with the fields but whenever i refresh i face a message box

the text of the message box is as follows

***********************************************************************************************

-


Crystal Reports

-


Failed to open a rowset.

Details: ADO Error Code: 0x80040e14

Source: Microsoft OLE DB Provider for Oracle

Description: ORA-06550: line 1, column 42:

PLS-00363: expression ' NULL' cannot be used as an assignment target

ORA-06550: line 1, column 7:

PL/SQL: Statement ignored

Native Error: 6550

-


OK

-


***********************************************************************************************

My stored procedure code is as follows

-


Create or Replace Package pckReports

AS

type agent_list is ref cursor return BAT_AGENTLIST%rowtype;

END;

CREATE or REPLACE PROCEDURE BatAgentlistReport (p_Recordset IN OUT pckReports.agent_list) AS

BEGIN

Open p_Recordset FOR

select * from bat_agentlist;

END;

-


The Ole db version is :- 10.1.0.4.0

The stored procedure is developed in Oraclient10g.

I am developing the stored procedure from the microsoft visual studio using a connection with the provider :- OraOLEDB.Oracle.1

Can anybody help me on this.