[Mono-dev] Maybe a System.Data.OracleClient.dll bug

[Leszek Ciesielski]

On 9/21/06, David <jiangchengyao at gmail.com> wrote:
>
>
> 2006/9/19, Leszek Ciesielski <skolima at gmail.com>:
> > This has already been reported (check
> > http://bugzilla.ximian.com/show_bug.cgi?id=79004 and
> > http://bugzilla.ximian.com/show_bug.cgi?id=78840 ). Could
> you please
> > try the OracleClient from the repository? I was not able to replicate
> > the bug with the current svn code (although I am not 100% certain it
> > works correct).
> >
> >
>
> I've tried the OracleClinet from the repository.
> But it still have the problem with the current code.
>
>
Could you please clarify this? If I get you right, you mean that the
code in the repository does not work, and mono 1.1.17.1  does not
work.

Surely the code will work if you do it as a single sql statement (if
it does not, things are FUBAR ;-) ), but it is (in regard to
performance) better to use OracleParameter. Inserting values into the
query string manualy is a workaround, but an ugly one, if you ask me.
Can you please send me both the code you use to create the table and
the c# code you have tried to execute? And information about such
things as locale settings, encoding and so on, both on your machine
and in the database?