CODEWITHSUNDEEP
c#oracle-databaselong-integer
TechGuy
TechGuy

Reputation: 4560

Store Large value in Oracle Database from C#

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 ?

Upvotes: 0

Views: 160

Answers (1)

Derviş Kayımbaşıoğlu
Derviş Kayımbaşıoğlu

Reputation: 30545

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

decimal.Parse(this.txtSubAgency.Text)

Upvotes: 4

Related Questions