#29 v2.2 uninstall misses two views

[Michael J. O'Neill]

Using utPLSQL 2.2 & 10gR2(Personal)

The following could be appended to ut_i_uninstall.sql

SET TERMOUT ON
PROMPT &line1
PROMPT DROPPING &UT VIEWS
PROMPT &line1

drop view UTV_RESULT_FULL;
drop view UTV_LAST_RUN;

I've attached the resultant file if you want to merge
it into the next release.

[Michael J. O'Neill]

new and improved uninstall script

[Paul Walker]

To Reproduce

1. Install utPLSQL (ut_i_do install)
2. Uninstall utPLSQL (ut_i_do uninstall)

3. Run: SELECT * FROM all_objects WHERE object_name IN ('UTV_RESULT_FULL', 'UTV_LAST_RUN);

4. The problem is that the above statement returns two Views - it should not return anything.

[Paul Walker]

I have merged the updated version provided by Michael J. O'Neill [above) into a branch in SVN [r122].

This now needs testing

[Paul Walker]

This looks to be working fine, so I've merged it into the trunk [r123], ready to be included in the next release