René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Uninstall script: buffer overflow error","articleBody":"**Describe the bug**\r\n\r\nWhile using the `uninstall.sql` script I got the following error:\r\n\r\n```\r\nORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes\r\n```\r\n\r\nThis 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:\r\n\r\n```\r\n    begin\r\n      execute immediate 'drop '||syn.syn_name;\r\n      dbms_output.put_line('Dropped '||syn.syn_name||' for object '||syn.for_object);\r\n      exception\r\n      when others then\r\n      dbms_output.put_line('FAILED to drop '||syn.syn_name||' for object '||syn.for_object);\r\n    end;\r\n```\r\n\r\nSo the block exits and not all of the synonyms are dropped.\r\n\r\n**Provide version info**\r\nOracle 12.1.0.2.0\r\nutPLSQL v3.1.11\r\n\r\n**Information about client software**\r\nA rather old version of SQL*Plus\r\n\r\n**Expected behavior**\r\nAll the synonyms are dropped and all the messages are logged.\r\n","author":{"url":"https://github.com/kukimik","@type":"Person","name":"kukimik"},"datePublished":"2022-07-28T08:57:34.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/1220/utPLSQL/issues/1220"}