Re: Error accessing package DBMS_APPLICATION_INFO

From: Sanjay Kulkarni <SSKULKAR_at_SYSTEMS.uwaterloo.ca>
Date: 1997/03/18
Message-ID: <5gn1s6$d34_001@watstar.uwaterloo.ca>#1/1

In article <332C82E8.10D6_at_qrcsun.qrc.org>,

   "Lun Wing San (Oracle)" <wslun_at_qrcsun.qrc.org> wrote:
>Bruce Cota wrote:
>>
>> I get this error:
>>
>> Error accessing package DBMS_APPLICATION_INFO
>
> Try to run dbmsutil.sql.
>
>---
>Name : Lun Wing San (Certified Oracle Database Administrator)
>
>Title : Oracle Database Administrator and System Administrator of QRC
>Phone : (852)27885841
>
>This posting represents the personal opinions of the author. It is not the
>official opinion or policy of the author's employer. Warranty expired when
 you
>opened this article and I will not be responsible for its contents or use.

I'd rerun catproc.sql first (as SYS). This will recreate the packages for the procedural option (PL/SQL). Also running pupbld.sql as SYSTEM may be needed.  This message usually occurs when a new db has been created, and the initialization scripts have not yet been run. The error CAN be safely ignored.

Sanjay Kulkarni
sskulkar_at_uwaterloo.ca

---

Sanjay Kulkarni
550 Glen Forrest Blvd.
N2L 4J6
519 884-2752 Received on Tue Mar 18 1997 - 00:00:00 CST