ORA-01858:在非数字字符中找到了数字 [英] ORA-01858: a non-numeric character was found where a numeric

问题描述

我正在asp.net网站上工作
我正在从用户那里获取输入并将其插入数据库中.
当我从oracle数据库运行插入查询时，记录已成功插入.
但是，当我尝试从程序运行相同的查询时，出现错误-ORA-01858:在数字
处发现了一个非数字字符
有人可以解决它吗?

I m working on the asp.net website
I m taking inputs from user and inserting in database.
When i run insert query from oracle database,the record is getting inserted successfully.
But when i try to run the same query from program, i m getting error-ORA-01858: a non-numeric character was found where a numeric

can someone how to solve it?

推荐答案

检查您的语言设置；如果您的程序使用的是GERMAN，但是数据库使用的是AMERICA，反之亦然，并且您输入的数字值带有小数位，则会收到此错误

Check your language settings; if your program uses i.e. GERMAN but the database uses AMERICA or vice versa, and you enter a numeric value with decimal places, you will receive this error

这篇关于ORA-01858:在非数字字符中找到了数字的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！