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

Crystal Reports 10 accessing Stored Procedure from oracle.


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





My stored procedure code is as follows


Create or Replace Package pckReports


type agent_list is ref cursor return BAT_AGENTLIST%rowtype;


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


Open p_Recordset FOR

select * from bat_agentlist;



The Ole db version is :-

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.