06502, 00000, "PL/SQL: numeric or value error%s"
// *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 99 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. 

SCOTT@orcl_12.1.0.2.0> select UTL_RAW.cast_to_number(rawtohex(to_char(trim('JSC010')))) from dual
  2  /
select UTL_RAW.cast_to_number(rawtohex(to_char(trim('JSC010')))) from dual
       *
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "SYS.UTL_RAW", line 388


SCOTT@orcl_12.1.0.2.0> select UTL_RAW.cast_to_number(rawtohex(cast(trim('JSC010') as char(21)))) from dual
  2  /

UTL_RAW.CAST_TO_NUMBER(RAWTOHEX(CAST(TRIM('JSC010')ASCHAR(21))))
----------------------------------------------------------------
                                                      -1.835E-23

1 row selected.

SCOTT@orcl_12.1.0.2.0> create table test (val char(9))
  2  /

Table created.

SCOTT@orcl_12.1.0.2.0> insert into test (val) values ('JSC010')
  2  /

1 row created.

SCOTT@orcl_12.1.0.2.0> select UTL_RAW.cast_to_number(rawtohex(to_char(val))) AS Sort_Dealer from test
  2  /
select UTL_RAW.cast_to_number(rawtohex(to_char(val))) AS Sort_Dealer from test
       *
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "SYS.UTL_RAW", line 388


SCOTT@orcl_12.1.0.2.0> select UTL_RAW.cast_to_number(rawtohex(to_char(cast(val as char(21))))) AS Sort_Dealer from test
  2  /

SORT_DEALER
-----------
 -1.835E-23

1 row selected.