« Return to Thread: ref cursor issue in oracle stored procedure invoked from mono

ref cursor issue in oracle stored procedure invoked from mono

by sumesh0710 :: Rate this Message:

Reply to Author | View in Thread

Hi,
OS - Linux Version 2.6.9-42.0.0.0.1( Red hat version 3.4.6-3.1)
Oracle - 9.2.0
mono - 1.2.4

I have a simple procedure which has a ref cursor as parameter as follows.

CREATE OR REPLACE PROCEDURE "DARSTRAN"."TEST" (crsdata out sys_refcursor)
as

BEGIN
open crsdata for select sysdate from dual;
END;


If i execute this from proc from sql plus. It works fine. Also in windows OS, if i call from an application developed in vb.net it will work. But same code executed in mono in Linux OS shows below error while filling into dataset.
ora- 01403: no data found.

Code used is

cmdSp = New OracleCommand("test", con)
cmdSp.CommandType = CommandType.StoredProcedure
ds = New DataSet
oprCursor = New OracleParameter("crsdata", OracleType.Cursor)
oprCursor.Direction = ParameterDirection.Output
cmdSp.Parameters.Add(oprCursor)
dasp = New OracleDataAdapter(cmdSp)
dasp.Fill(ds)


If i execute above SP from linux sql plus, also it works ok.

Is there any workaround to solve this problem?

 « Return to Thread: ref cursor issue in oracle stored procedure invoked from mono