Re: DBMS_OUTPUT... buffer full !!

1. As Norman Dunbar has suggested use DBMS_OUTPUT.Enable(1000000) if that size too is not sufficient,
2. Put each DBMS_OUTPUT line in its own block and handle the exception

ex
stmt1;
stmt2;
....

BEGIN
 DBMS_OUTPUT.PUT_LINE('............');
EXCEPTION
 WHEN ..... THEN
  NULL;
END;
....

... Received on Mon Aug 05 2002 - 23:25:49 CDT