Re: Before turning to oracle support.......component 'DBMS_SYS_SQL' must be declared
Date: Thu, 3 Jul 2008 08:06:01 -0700 (PDT)
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
> 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.
-- jeremyReceived on Thu Jul 03 2008 - 10:06:01 CDT