Re: Before turning to oracle support.......component 'DBMS_SYS_SQL' must be declared
From: jeremy <jeremy0505_at_gmail.com>
Date: Thu, 3 Jul 2008 08:09:45 -0700 (PDT)
Message-ID: <af0ec2ea-ecf2-44b1-9a37-4f85504cd410@d45g2000hsc.googlegroups.com>
Date: Thu, 3 Jul 2008 08:09:45 -0700 (PDT)
Message-ID: <af0ec2ea-ecf2-44b1-9a37-4f85504cd410@d45g2000hsc.googlegroups.com>
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.
-- jeremyReceived on Thu Jul 03 2008 - 10:09:45 CDT