Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options


SQL> select * from nls_database_parameters where parameter='NLS_CHARACTERSET';

PARAMETER                      VALUE
------------------------------ ----------------------------------------
NLS_CHARACTERSET               CL8MSWIN1251


SQL> desc t
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 ID                                                 NUMBER(38)
 N                                                  VARCHAR2(4000)

SQL> declare
  2   type t is table of varchar2(32000);
  3   v_t t :=t();
  4   v_v varchar2(4000);
  5  begin
  6   v_t.extend(1);
  7   v_t(1):=lpad('*',32000,'+');
  8   v_v:=substr(v_t(1),1,4000);
  9   insert into t values(1,v_v);
 10   insert into t values(2,substr(v_t(1),1,4000));
 11  end;
 12  /
declare
*
ERROR at line 1:
ORA-01461: can bind a LONG value only for insert into a LONG column
ORA-06512: at line 10