when i Export my excel file from Datbase with Number (38) g

Question

when i Export my excel file from Datbase with Number (38) gets the error: Decimal's scale value must be between 0 and 28 inclusive. Parameter name: scale Please help.

rakesh chaudhari · Answer

thanks for u r reply but my excel contains 50000 rows so when i cast using this Cast the returned value to a varchar cast (fff as varchar(99)) fff On the ADO side convert it back drow.fff = Convert.ToDouble(drdr.GetString(ncolFFF)); it is more slower

Manas Mohapatra · Answer

It is problem with Number type scaling. Please see below link it is resolved and it will help you also.. https://social.msdn.microsoft.com/Forums/sqlserver/en-US/f7b7636d-7475-4848-8bc0-d1c10e36707e/ssma-oracle-sql-v40-error-decimals-scale-value-must-be-between-0-and-28-inclusive?forum=sqlgetstarted

when i Export my excel file from Datbase with Number (38) g

Decimal's scale value must be between 0 and 28, inclusive. Parameter name: scale

Decimal's scale value must be between 0 and 28, inclusive.
Parameter name: scale