Store Large value in Oracle Database from C#

Question

I want to store 20 numbers(eg.12345678901234567890) in oracle database. I've used NUMBER data type in oracle database and when I pass long data type from the C# end it's getting error,

Error is : Value was either too large or too small for an Int64.

Code

 _newsObj.SUB_AGENCY_ID = long.Parse(this.txtSubAgency.Text);

How can i store my above example data in oracle database ?

score 4 · Accepted Answer · answered Oct 08 '20 at 17:51

4

c# cannot store 12345678901234567890 big number, you can use decimal instead.

decimal.Parse(this.txtSubAgency.Text)

answered Oct 08 '20 at 17:51

Derviş Kayımbaşıoğlu

28,492
4
50
72

Is this value can store NUMBER field in Oracle ? – TechGuy Oct 08 '20 at 18:01
2

yes sure, there is nothing to do with oracle. NUMBER can store up to 38 digits length – Derviş Kayımbaşıoğlu Oct 08 '20 at 18:13

Store Large value in Oracle Database from C#

Code

1 Answers1