◐ Shell
clean mode source ↗

Fix uninstall scripts by jgebal · Pull Request #1221 · utPLSQL/utPLSQL

@jgebal

Fixing problem with uninstall script buffer overflow on DBMS_OUTPUT.
Resolves: #1220

Fixing problem with uninstall script buffer overflow on DBMS_OUTPUT.
Reolves: #1220

@github-actions

Unit Test Results

       1 files         2 suites   4m 31s ⏱️
1 025 tests 1 020 ✔️ 4 💤 0  1 🔥
1 028 runs  1 019 ✔️ 8 💤 0  1 🔥

For more details on these errors, see this check.

Results for commit 4f944a6.

♻️ This comment has been updated with latest results.

@kukimik

Note that with serveroutput turned off, failure to drop a synonym is likely to get unnoticed. See the error handling in uninstall_synonyms.sql:

, - the exceptions are silenced.

By the way, also this i := i + 1; should be put after execute immediate succeeds. Maybe it can also be fixed here. Mentioning any failures in the summaries ( dbms_output.put_line(i||' synonyms dropped');) could also be helpful.

@jgebal

@jgebal jgebal deleted the jgebal-patch-1 branch

August 15, 2022 10:51