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

On 3 Jul, 15:32, jeremy <jeremy0..._at_gmail.com> 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:
>
>  [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

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 Received on Thu Jul 03 2008 - 09:57:40 CDT