https://bugzilla.novell.com/show_bug.cgi?id=480377
User [email protected] added comment https://bugzilla.novell.com/show_bug.cgi?id=480377#c1 --- Comment #1 from WebServices Group <[email protected]> 2009-02-27 08:05:09 MST --- Sorry, I accidentally submitted the bug before I could finish the description. Example Oracle procedure: PROCEDURE SUBTRACT_TWO_DATES ( ret_cur OUT SYS_REFCURSOR ) AS time1 DATETIME := '01-FEB-09 12:00:00 AM'; time2 DATETIME := '02-FEB-09 12:00:00 AM'; BEGIN OPEN ret_cur FOR SELECT (time2 - time1) FROM DUAL; END; C# code consists of merely invoking the procedure then attempting to read the cursor with a DataReader: System.Data.OracleClient.OracleCommand cmd = new System.Data.OracleClient.OracleCommand(); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.CommandText = "SUBTRACT_TWO_DATES"; cmd.Connection = myConnection; // you'll have to create myConnection first... System.Data.OracleClient.OracleParameter ret_cur_param = new System.Data.OracleClient.OracleParameter(); ret_cur_param.ParameterName = "ret_cur"; ret_cur_param.OracleType = System.Data.OracleClient.OracleType.Cursor; ret_cur_param.Direction = System.Data.ParameterDirection.Output; ret_cur_param.Value = System.DBNull.Value; cmd.Parameters.Add(ret_cur_param); cmd.ExecuteNonQuery(); System.Data.DataTable myTable = new System.Data.DataTable("ret_cur"); using (System.Data.OracleClient.OracleDataReader reader = new System.Data.OracleClient.OracleDataReader(ret_cur_param.Value)) { myTable.Load(reader); // blows up here when an INTERVAL is in the result set } I apologize if there are miscellaneous typos or syntax errors above; it is hand-typed -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA contact for the bug. _______________________________________________ mono-bugs maillist - [email protected] http://lists.ximian.com/mailman/listinfo/mono-bugs
