Problem: When I turn dbms server output on and run a query with loads of dbms_output.put_line statements I get an error telling me the dbms output buffer is too small. Can anyone tell me if I can increase the buffer size? These don’t seem to work:
–SET SERVEROUTPUT ON size ‘999999999999999999999999999999999999999’;
It would also be great if I could pipe the output to a file instead of the output window. Is that possible?