◐ Shell
clean mode source ↗

Uninstall script: buffer overflow error

Describe the bug

While using the uninstall.sql script I got the following error:

ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes

This happened in the "Dropping synonyms pointing to non-existing objects in schema UT3" part of the script (see source/unistall_synonyms.sql). The exception handler does not handle this gracefully, as it tries to write to the buffer which is already overflown:

    begin
      execute immediate 'drop '||syn.syn_name;
      dbms_output.put_line('Dropped '||syn.syn_name||' for object '||syn.for_object);
      exception
      when others then
      dbms_output.put_line('FAILED to drop '||syn.syn_name||' for object '||syn.for_object);
    end;

So the block exits and not all of the synonyms are dropped.

Provide version info
Oracle 12.1.0.2.0
utPLSQL v3.1.11

Information about client software
A rather old version of SQL*Plus

Expected behavior
All the synonyms are dropped and all the messages are logged.