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')”,里面的时间格式不正确。
以后写程序时一定要加强对数据合法性的校验。
 
                    
                     
                    
                 
                    
                 
 
                
            
         
         浙公网安备 33010602011771号
浙公网安备 33010602011771号