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

On 3 Jul, 16:09, jeremy <jeremy0..._at_gmail.com> wrote:
> 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
>
> Was also going to point out there is a huge list of other packages
> which are invalid in the SYS schema - all as a result I think of the
> problem with DBMS_SYS_SQL.
>
> --
> jeremy

As SYS, @?/rdbms/admin/prvtssql.plb recreate the DBMS_SYS_SQL package.

HTH -g Received on Thu Jul 03 2008 - 10:36:58 CDT