Re: package UTL_MAIL - 04042
From: ddf <oratune_at_msn.com>
Date: Tue, 27 Sep 2011 15:44:26 -0700 (PDT)
Message-ID: <7d346ac5-69a6-47d8-a525-2989e2423ecc_at_n12g2000yqh.googlegroups.com>
On Sep 27, 3:42 pm, ddf <orat..._at_msn.com> wrote:
> On Sep 23, 8:30 am, Pif 34 <pi..._at_nospam.fr> wrote:
>
> > Hello,
>
> > i'm following tutorial on how to send email in Oracle 10g. When I try to
> > grant access to package UTL_MAIL, I get an error of "package not exists"
> > (ORA-04042). This is not an express edition.
>
> > grant execute on UTL_MAIL to public;
>
> > An idea on why and how to correct ?
>
> > Thanks.
>
> It's likely not there; it is not installed by default so you have to
> install it.
>
> David Fitzjarrell
Date: Tue, 27 Sep 2011 15:44:26 -0700 (PDT)
Message-ID: <7d346ac5-69a6-47d8-a525-2989e2423ecc_at_n12g2000yqh.googlegroups.com>
On Sep 27, 3:42 pm, ddf <orat..._at_msn.com> wrote:
> On Sep 23, 8:30 am, Pif 34 <pi..._at_nospam.fr> wrote:
>
> > Hello,
>
> > i'm following tutorial on how to send email in Oracle 10g. When I try to
> > grant access to package UTL_MAIL, I get an error of "package not exists"
> > (ORA-04042). This is not an express edition.
>
> > grant execute on UTL_MAIL to public;
>
> > An idea on why and how to correct ?
>
> > Thanks.
>
> It's likely not there; it is not installed by default so you have to
> install it.
>
> David Fitzjarrell
Connect as SYS as sysdba:
SQL> _at_?/rdbms/admin/utlmail
...
SQL> _at_?/rdbms/admin/prvtmail.plb
...
David Fitzjarrell Received on Tue Sep 27 2011 - 17:44:26 CDT