Have you tried building mono from svn? Also, can you file a bug in bugzilla please?
--- On Tue, 9/2/08, sumesh0710 <[EMAIL PROTECTED]> wrote: > From: sumesh0710 <[EMAIL PROTECTED]> > Subject: [Mono-list] re f cursor issue in oracle stored procedure invoked > from mono > To: [email protected] > Date: Tuesday, September 2, 2008, 10:27 AM > 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. > > _______________________________________________ > Mono-list maillist - [email protected] > http://lists.ximian.com/mailman/listinfo/mono-list _______________________________________________ Mono-list maillist - [email protected] http://lists.ximian.com/mailman/listinfo/mono-list
