[Mono-list] re f cursor issue in oracle stored procedure invoked from mono

[sumesh0710]

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?
-- 
View this message in context: http://www.nabble.com/ref-cursor-issue-in-oracle-stored-procedure-invoked-from-mono-tp19271280p19271280.html
Sent from the Mono - General mailing list archive at Nabble.com.