Looks like you are using dbms_output for something. By default, you can only spool 2000 bytes using dbms_output. You can increase it by using the dbms_output.enable method:
dbms_output.enable(1000000);