Menu ▾ ▴

#11 Packages still invalid after installation

Closed-UnableToReproduce
Paul Walker
None
[other - please specify]
[Unknown]
Medium
[unknown]
2013-10-20
2002-10-09
Alex Sokol
No

After correcting installtion/uninstallation errors I
discovered that 2 packages are still invalid even though
installation didn't display any errors:
UTPLSQL_UTIL
UT_UTOUTPUT
after an attempt to compile them manually received the
following errors:
for UTPLSQL_UTIL:
PLS-00201: identifier 'UTPLSQL.TRACING' must be
declared

for UT_UTOUTPUT:
PLS-00201: identifier 'UTASSERT.EQ' must be declared

The subsequent uninstall also ran without errors
displayed but displayed the message in the end:

Possible utPLSQL Objects Not Successfully Un-installed

OBJECT_NAME
------------------------------
UTOUTPUT
UTOUTPUT
UTPLSQL_UTIL
UTPLSQL_UTIL
UT_GRID
UT_REFCURSOR_RESULTS_SEQ
UT_UTOUTPUT
UT_UTOUTPUT

Quick search through utplsql_uninstall.sql revealed
that all these objects are not dropped.

Discussion

  • Paul Walker

    Paul Walker - 2013-10-12
    • Status: open --> Open
    • Priority: 5 --> Medium
     

  • Paul Walker

    Paul Walker - 2013-10-12
    • Fixed in version: --> [none]
     

  • Paul Walker

    Paul Walker - 2013-10-20

    I have installed and uninstalled the current version (2.2) numerous times and not encountered these errors. I assume they have been fixed in an interim version.

     

  • Paul Walker

    Paul Walker - 2013-10-20
    • summary: Packages still invalid after installatio --> Packages still invalid after installation
    • status: Open --> Closed-UnableToReproduce
    • assigned_to: Paul Walker
    • Seen in version: --> [other - please specify]
    • Oracle version: --> [Unknown]
    • Fixed in version: [none] --> [unknown]
     

Log in to post a comment.