Re: package UTL_MAIL - 04042
From: ddf <oratune_at_msn.com>
Date: Tue, 27 Sep 2011 15:48:10 -0700 (PDT)
Message-ID: <53251d4f-4921-4006-a814-32aa82d066fa_at_q24g2000vby.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:48:10 -0700 (PDT)
Message-ID: <53251d4f-4921-4006-a814-32aa82d066fa_at_q24g2000vby.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
As sys as sysdba:
_at_?/rdbms/admin/utlmail
_at_?/rdbms/admin/prvtmail.plb
Those scripts will install UTL_MAIL.
David Fitzjarrell Received on Tue Sep 27 2011 - 17:48:10 CDT