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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.