Forum OpenACS Improvement Proposals (TIPs): Re: TIP #65: (Approved) Modify APM to recompile busted Oracle PACKAGE and PACKAGE BODY objects after upgrade

Collapse
14: Re: TIP #65: (Approved) Modify APM to recompile busted Oracle PACKAGE and PACKAGE BODY objects after upgrade (response to 1)
Posted by Andrew Grumet on 06/07/04 09:17 PM
utlrp.sql does not run as a normal user.

SQL> @/oracle/m00/app/oracle/product/8.1.7/rdbms/admin/utlrp
          from obj$ o, user$ u
                *
ERROR at line 25:
ORA-06550: line 25, column 17:
PLS-00201: identifier 'OBJ$' must be declared
[blah blah blah]