package UTL_MAIL - 04042

#1

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.

#2

On Sep 23, 8:30*am, Pif 34 <pi... (AT) nospam (DOT) fr> wrote:

Quote:

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

#3

On Sep 27, 3:42*pm, ddf <orat... (AT) msn (DOT) com> wrote:

Quote:

On Sep 23, 8:30*am, Pif 34 <pi... (AT) nospam (DOT) 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> @?/rdbms/admin/utlmail

....

SQL> @?/rdbms/admin/prvtmail.plb

....

David Fitzjarrell

#4

On Sep 27, 3:42*pm, ddf <orat... (AT) msn (DOT) com> wrote:

Quote:

On Sep 23, 8:30*am, Pif 34 <pi... (AT) nospam (DOT) 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:

@?/rdbms/admin/utlmail
@?/rdbms/admin/prvtmail.plb

Those scripts will install UTL_MAIL.

David Fitzjarrell

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

package UTL_MAIL - 04042

comp.databases.oracle.misc comp.databases.oracle.misc

package UTL_MAIL - 04042 - 09-23-2011 , 10:30 AM

Re: package UTL_MAIL - 04042 - 09-27-2011 , 05:42 PM

Re: package UTL_MAIL - 04042 - 09-27-2011 , 05:44 PM

Re: package UTL_MAIL - 04042 - 09-27-2011 , 05:48 PM