Originally posted by slimdave
i wonder if "varchar2(30000)" is part of the problem. varchar2 only goes to 4000.
Dave,

I don't know if you right but here is my test :
1 declare
2 cursor c1 is select table_name from dba_tables where owner='TROPP' ;
3 tname varchar2(50000):= null ;
4 begin
5 for i in c1
6 loop
7 tname:= i.table_name||',';
8 end loop;
9 dbms_output.put_line(tname);
10* end;
SQL>/
tname varchar2(50000):= null ;
*
ERROR at line 3:
ORA-06550: line 3, column 10:
PLS-00215: String length constraints must be in range (1 .. 32767)