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

On 3 Jul, 15:57, gazzag <gar...@[EMAIL PROTECTED]
> 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