Ora 01722 invalid number updating date

ORA-01722 also may occurs with comparison of string and number in sql. Examples 1: We can simply avoid ORA-01722 by following simple guidelines. Asked: December 23, 2011 - am UTC Answered by: Tom Kyte - Last updated: September 16, 2012 - am UTC Category: Developer - Version: 11.2.0.1.0 Viewed 10K times!

ora 01722 invalid number updating date-16ora 01722 invalid number updating date-52

September 16, 2012 - am UTC I think their "business rule" is such that "when y=4, we have stored a number in varchar2_column" their assumption is all data would be convertible at that point.Hi tom, Is there any hints useful to handle this kind of issue?I know some like NO_MERGE, NO_PUSH_PRED, MATERIALIZE but seems not work during my testing.If it does, is there a way to get the CBO to output the error?Regards Ravi September 14, 2012 - pm UTC the CBO cannot output the error, there isn't any error until the implicit conversion actually happens.

Leave a Reply