[Oracle-Error] ORA-017222:”invalid number”

• ORA-017222: 수치가 부적합합니다.

AnORA-01722("invalid number") error occurs when an attempt is made to convert a character string into anumber, and the string cannot be converted into a valid number. Valid numbers contain the digits '0' through '9', with possibly one decimal point, a sign (+ or -) at the beginning or end of the string, or an 'E' or 'e' (if it is a floating point number in scientific notation). All other characters are forbidden.

There are numerous situations where this conversion may occur. A numeric column may be the object of an INSERT or an UPDATE statement. Or, a numeric column may appear as part of a WHERE clause. It is even possible for this error to appear when there are no numeric columns appearing explicitly in the statement!

-  문자열(String) 을 숫자(Number) 로 변환할 때 발생하는 오류이다.

- TYPE이 일치 하지 않는 경우에 종종 발생.

  TYPE잘 확인하고 작성하자. 숫자인데 문자를 쓸 수는 없으니까.