I have a table with column datatype NUMBER. Without precise and scale.
From C# app I cant insert Decimal value. All others columns are filled correctly only with this Number I have every time 0.
In case of specified NUMBER with precise and scale like NUMBER(22,2) everything is ok.
Is the some kind of problem with mapping Decimal to unspecified NUMBER in Odt.Net?
Works fine here.
Got a concise, yet complete, sample (including versions)?
SQL> create table demo.mtest(c number) tablespace users; Table created. = = = = string sql = "insert into mtest values (:0)"; OracleCommand cmd = con.CreateCommand(); cmd.CommandText = sql; cmd.Parameters.Add(null, OracleDbType.Decimal, ParameterDirection.Input).Value = 3.1415926; cmd.ExecuteNonQuery(); = = = = SQL> select * from demo.mtest; C ---------- 3.1415926 1 row selected.