SQL>
SQL> CREATE TABLE myItemTable (
2 item_code varchar2(6) PRIMARY KEY,
3 item_descr varchar2(20) NOT NULL);
Table created.
SQL>
SQL> DECLARE
2 v_item_code VARCHAR2(6);
3 v_item_descr VARCHAR2(20);
4 BEGIN
5 v_item_code :='rntsoft';
6 v_item_descr :='a web site for Oracle';
7 INSERT INTO myItemTable VALUES (v_item_code,v_item_descr);
8 EXCEPTION WHEN OTHERS THEN
9 dbms_output.put_line(SQLERRM);
10 END;
11 /
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
PL/SQL procedure successfully completed.
SQL>
SQL> select * from myItemTable;
no rows selected
SQL>
SQL> drop table myItemTable;
Table dropped.
SQL>