[Mono-dev] Bug 486705 Update / Fix? - OracleClient parameter always zero
monodanmorg at yahoo.com
Fri Mar 20 07:13:41 EDT 2009
I have made your suggested fix to OracleClient.
It was committed as revision 129864 in svn trunk.
--- On Thu, 3/19/09, Thracx <SpamMonkey01+Mono at gmail.com> wrote:
> From: Thracx <SpamMonkey01+Mono at gmail.com>
> Subject: [Mono-dev] Bug 486705 Update / Fix?
> To: mono-devel-list at lists.ximian.com
> Date: Thursday, March 19, 2009, 12:47 PM
> I might have found the source of Bug
> 486705. For whatever reason, I am unable to create a Novell
> account so if someone could post this info to that Bug
> on my behalf, it would be much appreciated.
> I wrote this a while back before I had the latest
> source code, but I thought I should just post it anyway for
> others to find when searching.
> 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 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
> 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.
> View this message in context: Bug
> 486705 Update / Fix?
> Sent from the Mono -
> Dev mailing list archive at Nabble.com.
More information about the Mono-devel-list