Re: ORA-06550 on Oracle Web Server?

From: Chris Kimpton <chris.kimpton_at_btalexbrown.com>
Date: Fri, 17 Jul 1998 08:20:05 +0100
Message-ID: <35AEFB25.D13F5709@btalexbrown.com>

Bits 'n' Bytes wrote:

> I've been seeing the following error occur randomly on our Oracle Web
> Server 2.1.1.0.0 using Oracle 7.3.3.0.0 on the OWS system, and 7.3.3.5.0
> on the remote database where the PL/SQL is being executed.
>
> Thu Jul 16 09:59:23 1998
> OWS-05105: Agent : authorization failed due to Oracle error 6550
> ORA-06550: line 1, column 143:
> PLS-00201: identifier 'AUTHORIZE' must be declared
> ORA-06550: line 1, column 139:
> PL/SQL: Statement ignored
>
>

How often do you restart the webserver? We've found we have to restart it daily (although we're on HPUX, OWS3.0.1.8, Oracle 7.3.3.?).

Regards,
Chris

> Operating system is Solaris 2.6 on the 7.3.3.0.0 system, and Solaris 2.5.1
> on the 7.3.3.5.0 system.
>
> Bryan S. Leaman
> Systems Engineer
> leaman_at_bitbytes.com
Received on Fri Jul 17 1998 - 02:20:05 CDT