Closed
Description
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
51EA
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.
Metadata
Metadata
Assignees
Labels
No labels