https://bugzilla.novell.com/show_bug.cgi?id=486705
User [email protected] added comment https://bugzilla.novell.com/show_bug.cgi?id=486705#c1 Daniel Morgan <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #1 from Daniel Morgan <[email protected]> 2009-03-20 07:04:49 MST --- Bug fix committed to svn trunk as revision 129864. OracleCommand.cs: fix suggested by Thracx <[email protected]> where the parameter was always item zero for an out parameter. Email from Thracx on Thursday, March 19, 2009, 12:47 PM > ExecuteReader(...) of > System.Data.OracleClient.OracleCommand.cs (Line 580) does a > for-loop over p (0 thru Parameters.Count), yet the loop > itself does not use the loop-invariant (p) - instead > it always uses '0' (i.e. Parameters[0] on Line 581). > The code in OracleCommand.cs, method GetNextResults() > (Line 661) has the proper loop so my understanding is when > Mono first gets the OracleDataReader/RefCursor, it > should only get the first cursor. Later, > command.NextResult() will be called by the user which will > call GetNextResults() and properly get the next cursor. > > This would explain to my why ExecuteReader(...) never > worked for me, as my OUT cursors were never the first > parameter in the Stored Procedure. I've had to save a > reference to the OracleParameter when I declare it and then > use param.Value after a call to ExecuteNonQuery(...) (which > does work fine for multiple cursor out parameters). I think > this is a new bug, as I wasn't able to find anything > about it when searching (other than the possibly related Bug > 486705). > > This might explain Bug 486705 to me - Shao Jiaxing was able > to get his first cursor out but couldn't get any data > from any other cursors if the first parameter > wasn't a cursor. -- 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
