Stupid bugs in ODP.NET 9.2.0.4.01

  • Thread starter Thread starter msnews.microsoft.com
  • Start date Start date
M

msnews.microsoft.com

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?
 
Back
Top