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>
|