Re: Before turning to oracle sup****t.......component 'DBMS_SYS_SQL'

On 3 Jul, 15:32, jeremy <jeremy0...@[EMAIL PROTECTED]
> wrote:
> 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:
>
> =A0[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/**************@[EMAIL PROTECTED]
 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 =A0 =A0PL/SQL: Statement ignored
> 230/26 =A0 PLS-00302: component 'DBMS_SYS_SQL' must be declared
> 239/5 =A0 =A0PL/SQL: Statement ignored
> 239/9 =A0 =A0PLS-00302: component 'DBMS_SYS_SQL' must be declared
> 241/5 =A0 =A0PL/SQL: Statement ignored
> 241/9 =A0 =A0PLS-00302: component 'DBMS_SYS_SQL' must be declared
> 242/5 =A0 =A0PL/SQL: Statement ignored
> 242/9 =A0 =A0PLS-00302: component 'DBMS_SYS_SQL' must be declared
> 243/5 =A0 =A0PL/SQL: Statement ignored
> 243/9 =A0 =A0PLS-00302: component 'DBMS_SYS_SQL' must be declared
> 244/5 =A0 =A0PL/SQL: Statement ignored
> 244/9 =A0 =A0PLS-00302: component 'DBMS_SYS_SQL' must be declared
> 245/5 =A0 =A0PL/SQL: Statement ignored
> 245/9 =A0 =A0PLS-00302: component 'DBMS_SYS_SQL' must be declared
> 246/5 =A0 =A0PL/SQL: Statement ignored
> 246/9 =A0 =A0PLS-00302: component 'DBMS_SYS_SQL' must be declared
> 248/5 =A0 =A0PL/SQL: Statement ignored
> 248/19 =A0 PLS-00302: component 'DBMS_SYS_SQL' must be declared
> 250/5 =A0 =A0PL/SQL: Statement ignored
> 250/9 =A0 =A0PLS-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

Nothing's changed and this just started happening?  Are you sure?

Anyway, you may want to try "GRANT EXECUTE ON DBMS_SYS_SQL TO
<web_username>;"

You may also want to check on the security considerations on so doing.

HTH

-g