"msnews.microsoft.com" <sbcadmin@hotmail.com> wrote in message
news:unbNVHIlFHA.2444@tk2msftngp13.phx.gbl...
> 1. Execute this SQL
> DELETE FROM ... WHERE ROWNUM=1 RETURNING a,b INTO :pa,:pb
> with ExecuteNonQuery(), here a and b are number columns, and the two
> output
> parameters' datatype is set to DbType.Int64, you are ok where there is row
> in database, otherwise your app crashs.
>
> 2. Guess what the DbType of this parameter is:
> OracleParameter p = new OracleParameter("name",0L);
> it is DbType.AnsiString other than DbType.Int64.
>
> Oracle did not release any patch for it for so long time. How could it be
> a
> company?
>
>

Sahil Malik [MVP] wrote:

> I agree. I blogged about this earlier -
> http://codebetter.com/blogs/sahil.malik/archive/2005/07/20/129504.aspx

>
>
> - Sahil Malik [MVP]
> ADO.NET 2.0 book -
> http://codebetter.com/blogs/sahil.malik/archive/2005/05/13/63199.aspx
> ----------------------------------------------------------------------
> ---------------------
>
> "msnews.microsoft.com" <sbcadmin@hotmail.com> wrote in message
> news:unbNVHIlFHA.2444@tk2msftngp13.phx.gbl...
> > 1. Execute this SQL
> > DELETE FROM ... WHERE ROWNUM=1 RETURNING a,b INTO :pa,:pb
> > with ExecuteNonQuery(), here a and b are number columns, and the
> > two output
> > parameters' datatype is set to DbType.Int64, you are ok where there
> > is row in database, otherwise your app crashs.
> >
> > 2. Guess what the DbType of this parameter is:
> > OracleParameter p = new OracleParameter("name",0L);
> > it is DbType.AnsiString other than DbType.Int64.
> >
> > Oracle did not release any patch for it for so long time. How could
> > it be a
> > company?