[Mono-bugs] [Bug 486705] After Used OracleDataReader's NextResult Method, DataReader can't Read Rows Any More!

[bugzilla_noreply at novell.com]

https://bugzilla.novell.com/show_bug.cgi?id=486705

User monodanmorg at yahoo.com added comment
https://bugzilla.novell.com/show_bug.cgi?id=486705#c1


Daniel Morgan <monodanmorg at yahoo.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |monodanmorg at yahoo.com




--- Comment #1 from Daniel Morgan <monodanmorg at yahoo.com>  2009-03-20 07:04:49 MST ---
Bug fix committed to svn trunk as revision 129864.

OracleCommand.cs: fix suggested by Thracx <SpamMonkey01+Mono at gmail.com>
    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.