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

From: jeremy <>
Date: Thu, 3 Jul 2008 08:06:01 -0700 (PDT)
Message-ID: <>

On 3 Jul, 15:57, gazzag <> wrote:

> 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.

Yeah I would have asked exactly the same question - something has *always* changed... but how the hell I really couldn't tell. There are only 4 people who could possibly have done anything and I know they haven't.

But witch hunt is for later :)

Cannot even describe the object:

15:30:11 SQL> desc dbms_sys_sql
ORA-24372: invalid object for describe

Don't get "does not exist" but "invalid object for describe"

I am logged in as SYS.

Thinking must be possible to recompile from the .sql / .plb files supplied with the database, just looking up which ones they are - a reasonable approach?

BTW this is a simple dev database but is not being mistreated.

Received on Thu Jul 03 2008 - 10:06:01 CDT

Original text of this message