Before turning to oracle support.......component 'DBMS_SYS_SQL' must be declared

From: jeremy <jeremy0505_at_gmail.com>
Date: Thu, 3 Jul 2008 07:32:21 -0700 (PDT)
Message-ID: <79cb4c77-18eb-404d-a02a-a522d8cb2c15@m36g2000hse.googlegroups.com>

10gR2 on Windows 2000

All running absolutely fine. We develop applications using OHS / mod_plsql.

Suddenly we got a "page not found" error in the browser trying to access a package.procedure via the browser.

On looking at the OHS error log we see:

 [Thu Jul 03 14:19:58 2008] [error] [client 91.141.235.91] [ecid: 1215091198:10.200.200.6:3244:2568:22185,0] mod_plsql: /pls/proxy10g/ ic_login.screen HTTP-404 ORA-04063: package body "SYS.WPG_DOCLOAD" has errors\nORA-06508: PL/SQL: could not find program unit being called: "SYS.WPG_DOCLOAD"\nORA-06512: at line 23\n

We haven't (honest!) touched anything in this area so as a result am thoroughly puzzled as to what could have caused this to be unavailable.

I logged in to db as user SYS and did:

14:25:35 SQL> connect sys/**************@hpdev10g as sysdba Connected.

14:25:43 SQL>
14:25:43 SQL>
14:25:44 SQL>
14:25:44 SQL>
14:25:44 SQL> show errors package body wpg_docload

Errors for PACKAGE BODY WPG_DOCLOAD:

230/5    PL/SQL: Statement ignored
230/26   PLS-00302: component 'DBMS_SYS_SQL' must be declared
239/5    PL/SQL: Statement ignored
239/9    PLS-00302: component 'DBMS_SYS_SQL' must be declared
241/5    PL/SQL: Statement ignored
241/9    PLS-00302: component 'DBMS_SYS_SQL' must be declared
242/5    PL/SQL: Statement ignored
242/9    PLS-00302: component 'DBMS_SYS_SQL' must be declared
243/5    PL/SQL: Statement ignored
243/9    PLS-00302: component 'DBMS_SYS_SQL' must be declared
244/5    PL/SQL: Statement ignored
244/9    PLS-00302: component 'DBMS_SYS_SQL' must be declared
245/5    PL/SQL: Statement ignored
245/9    PLS-00302: component 'DBMS_SYS_SQL' must be declared
246/5    PL/SQL: Statement ignored
246/9    PLS-00302: component 'DBMS_SYS_SQL' must be declared
248/5    PL/SQL: Statement ignored
248/19   PLS-00302: component 'DBMS_SYS_SQL' must be declared
250/5    PL/SQL: Statement ignored
250/9    PLS-00302: component 'DBMS_SYS_SQL' must be declared

14:25:59 SQL> Before going to Oracle would anyone have any ideas as to the cause of this? I don't believe anyone in the team has done anything to the db setup (they don't have the privileges).

Any thoughts?

--
jeremy

Received on Thu Jul 03 2008 - 09:32:21 CDT