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

On 3 Jul, 15:57, gazzag <gar..._at_jamms.org> 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.
>
> HTH
>

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

--
jeremy