ORA-06502: PL/SQL: numeric or value error: character to number conversion error : ORA Error « System Packages « Oracle PL / SQL






ORA-06502: PL/SQL: numeric or value error: character to number conversion error

  
SQL> CREATE TABLE myTable2(
  2       e INTEGER,
  3       f INTEGER
  4   );

Table created.

SQL>
SQL> INSERT INTO myTable2 VALUES(1, 3);

1 row created.

SQL> INSERT INTO myTable2 VALUES(2, 4);

1 row created.

SQL>
SQL> CREATE or replace PROCEDURE addtuple2(
  2       x myTable2.e%TYPE,
  3       y myTable2.f%TYPE)
  4   AS
  5   BEGIN
  6       INSERT INTO myTable2(e, f)VALUES(x, y);
  7   END addtuple2;
  8   /

Procedure created.

SQL>
SQL> show errors
No errors.
SQL>
SQL> BEGIN
  2       addtuple2(10, 'abc');
  3   END;
  4   /
BEGIN
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at line 2


SQL>
SQL> drop table myTable2;

Table dropped.

SQL>
SQL>
SQL>
SQL>

   
    
  








Related examples in the same category

1.ORA-00918: column ambiguously defined
2.ORA-00934: group function is not allowed here
3.ORA-00979: not a GROUP BY expression
4.ORA-01403: no data found
5.ORA-01403: no data found exception from procedure
6.ORA-01422: exact fetch returns more than requested number of rows
7.ORA-01426: numeric overflow
8.ORA-01839: date not valid for month specified
9.ORA-06502: PL/SQL: numeric or value error
10.ORA-06502: PL/SQL: numeric or value error: number precision too large
11.ORA-06503: PL/SQL: Function returned without value
12.ORA-14551: cannot perform a DML operation inside a query