ORA-01858: a non-numeric character was found where a numeric was expected

程序操作Oracle数据库时,出现“ORA-01858: a non-numeric character was found where a numeric was expected”错误。

原因是语句中包含“lurudate = TO_DATE('197001ull','yyyymmddhh24mi')”,里面的时间格式不正确。

以后写程序时一定要加强对数据合法性的校验。

posted on 2012-11-06 10:01  onedime  阅读(45508)  评论(0编辑  收藏  举报