-6502 ORA-06502: PL SQL: numeric or value error: character to number conversion error
------解决方法--------------------------------------------------------
你要把你的SQL语句写出来的,这个肯定是你类型转换的问题
------解决方法--------------------------------------------------------
ORA-06502 PL/SQL: numeric or value errorstring
Cause : An arithmetic, numeric, string, conversion, or constraint error occurred. For example, this error occurs if an attempt is made to assign the value NULL to a variable declared NOT NULL, or if an attempt is made to assign an integer larger than 88 to a variable declared NUMBER(2).
Action: Change the data, how it is manipulated, or how it is declared so that values do not violate constraints.