Skip to Main Content
Forums

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Lost scale value when insert NUMBER(15,2) type

683536Feb 5 2009 — edited Nov 23 2010
Hi,

I'm trying to insert a value 253.65 in a NUMBER(15,2) collum table. Below is my code:

{color:#3366ff}
cmd.Parameters.Add(BuildOracleParam("vNF", OracleDbType.Decimal, "253.65",15,2));{color}

where BuildOracleParam(name, type, value, precision, scale) is simple a method that create and return a OracleParamenter.

but when select the colllum I get the value 253.00.

How to resolve this situation? some advice?

tnks
This post has been answered by gdarling - oracle on Feb 5 2009
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 21 2010
Added on Feb 5 2009
#oracle-provider-for-ole-db, #windows-and-net
5 comments
4,401 views