SQL> create table t (c1 varchar2(10),c2 varchar2(3));

Table created.

SQL> insert into t values ('123456789','123456789');
insert into t values ('123456789','123456789')
                                  *
ERROR at line 1:
ORA-12899: value too large for column "MICHEL"."T"."C2" (actual: 9, maximum: 3)

SCOTT@orcl_11gR2> SELECT * FROM v$version
  2  /

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE	11.2.0.1.0	Production
TNS for 64-bit Windows: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production

5 rows selected.

SCOTT@orcl_11gR2> CREATE TABLE emp_temp AS
  2  SELECT deptno, job
  3  FROM   EMP
  4  WHERE  1 = 2
  5  /

Table created.

SCOTT@orcl_11gR2> DESC emp_temp
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 DEPTNO                                             NUMBER(2)
 JOB                                                VARCHAR2(9)

SCOTT@orcl_11gR2> DECLARE
  2    TYPE	      emp_rec IS RECORD
  3  	 (deptno      emp.deptno%TYPE,
  4  	  job	      emp.job%TYPE);
  5    TYPE	      emp_tab IS TABLE OF emp_rec;
  6    emps	      emp_tab;
  7    e_too_big      EXCEPTION;
  8    PRAGMA	      EXCEPTION_INIT (e_too_big, -12899);
  9  BEGIN
 10    SELECT deptno, job
 11    BULK   COLLECT
 12    INTO   emps
 13    FROM   emp
 14    WHERE  deptno = 10;
 15    FORALL i IN 1 .. emps.COUNT
 16  	 INSERT INTO emp_temp VALUES
 17  	 (emps(i).deptno, emps(i).job || 'S');
 18  EXCEPTION
 19    WHEN e_too_big THEN
 20  	 DBMS_OUTPUT.PUT_LINE (SQLERRM);
 21  END;
 22  /
ORA-12899: value too large for column "SCOTT"."EMP_TEMP"."JOB" (actual: 10,
maximum: 9)

PL/SQL procedure successfully completed.

SCOTT@orcl_11gR2> SELECT * FROM emp_temp
  2  /

    DEPTNO JOB
---------- ---------
        10 MANAGERS

1 row selected.

SCOTT@orcl_11gR2> TRUNCATE TABLE emp_temp
  2  /

Table truncated.

SCOTT@orcl_11gR2> DECLARE
  2    TYPE	      emp_rec IS RECORD
  3  	 (deptno      emp.deptno%TYPE,
  4  	  job	      emp.job%TYPE);
  5    TYPE	      emp_tab IS TABLE OF emp_rec;
  6    emps	      emp_tab;
  7    save_attr_except     EXCEPTION;
  8    PRAGMA	      EXCEPTION_INIT (save_attr_except, -24381);
  9    errors	      NUMBER;
 10    l_iteration    VARCHAR2(100);
 11  BEGIN
 12    SELECT deptno, job
 13    BULK   COLLECT
 14    INTO   emps
 15    FROM   emp
 16    WHERE  deptno = 10;
 17    FORALL i IN 1 .. emps.COUNT SAVE EXCEPTIONS
 18  	 INSERT INTO emp_temp VALUES
 19  	 (emps(i).deptno, emps(i).job || 'S');
 20  EXCEPTION
 21    WHEN save_attr_except THEN
 22  	 errors := SQL%BULK_EXCEPTIONS.COUNT;
 23  	 FOR k IN 1 .. errors LOOP
 24  	   l_iteration := SQL%BULK_EXCEPTIONS(k).ERROR_INDEX;
 25  	   dbms_output.put_line(
 26  	     'Error: ' ||
 27  	     SQLERRM(-sql%BULK_EXCEPTIONS(k).ERROR_CODE) ||
 28  	     ' -> ' || DBMS_UTILITY.format_error_backtrace);
 29  	 END LOOP;
 30  END;
 31  /
Error: ORA-12899: value too large for column  (actual: , maximum: ) ->
ORA-06512: at line 17


PL/SQL procedure successfully completed.

SCOTT@orcl_11gR2> SELECT * FROM emp_temp
  2  /

    DEPTNO JOB
---------- ---------
        10 MANAGERS
        10 CLERKS

2 rows selected.

SCOTT@orcl_11gR2>