Monday, 6 July 2020

ORA-01722: invalid number

ORA-01722: invalid number
存入DB的資料不為Number,例如千分位顯示數字 1,000

【解決方式】將千分位移除
Request["txtTXN_QTY" + rows].ToString().Replace(",","")

No comments:

Post a Comment

IIS HTTP Error 403.18

 HTTP Error 403.18 - Forbidden The specified request cannot be processed in the application pool that is configured for this resource on the...