If the output is more than 32767, then sqlplus wont display it unless you turn wrap on (and then the line will wrap).
SQL> create table TABLE_XYZ ( col1 char(200) );
Table created.
SQL>
SQL> declare
2 ins_sql varchar2(32000) := q'{insert into TABLE_XYZ values ('x'}';
3 begin
4 for i in 2 .. 200 loop
5 execute immediate 'alter table TABLE_XYZ add col'||i||' char(200)';
6 ins_sql := ins_sql || ',''x''';
7 end loop;
8 execute immediate ins_sql||')';
9 end;
10 /
PL/SQL procedure successfully completed.
SQL>
SQL>
SQL> SET COLSEP ',' LINESIZE 32767 NUMWIDTH 18 LONG 2000 ECHO OFF
SQL> SET TRIMOUT ON ARRAYSIZE 5000 AUTOCOMMIT OFF FLUSH OFF HEADING ON TERMOUT OFF
SQL> SET PAUSE OFF SERVEROUTPUT ON TRIMSPOOL ON VERIFY OFF
SQL> SET UNDERLINE OFF PAGESIZE 0 ESCAPE OFF HEADING OFF FEEDBACK OFF WRAP OFF
SQL>
SQL> SELECT * from TABLE_XYZ;
rows will be truncated
rows will be truncated
rows will be truncated
...
...
SQL> set wrap on
SQL> SELECT * from TABLE_XYZ;
x ,x ,x
,x ,x ,x
,x ,x
,x ,x ,x
,x ,x
,x ,x ,x
,x ,x ,x
,x ,x
,x ,x ...