Re: Problems, to get utlsmtp up and running

From: Vladimir M. Zakharychev <bob_at_dpsp-yes.com>
Date: Thu, 30 Jan 2003 21:19:49 +0300
Message-ID: <b1bqdf$h23$1@babylon.agtel.net>

Connect as SYS, then issue

CREATE PUBLIC SYNONYM UTL_SMTP FOR SYS.UTL_SMTP; GRANT EXECUTE ON SYS.UTL_SMTP TO PUBLIC; (or to whoever wants to run the package if not everybody)

then retry.

--
Vladimir Zakharychev (bob@dpsp-yes.com)                http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.


"Oliver Demus" <oliver_at_demus-online.de> wrote in message
news:62e59750.0301270937.3207d19e_at_posting.google.com...


> Hi,

> I removed the EXEPTION, and get now the following error:

> ORA-04068: existing state of packages has been discarded

> ORA-04067: not executed, package body "TEST.UTL_SMTP" does not exist

> ORA-06508: PL/SQL: could not find program unit being called

> ORA-06512: at "TEST.SEND_MAIL_TEST", line 14

> ORA-06512: at line 1

>

> Can anybody tell me, how to grant, or to get this package body to TEST?

>

> Thanks

> Oliver

>

>

> Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl> wrote in message

news:<obl83vo4so0g6r166oetd31v5rfq1u58mo_at_4ax.com>...


> > On 26 Jan 2003 12:42:34 -0800, oliver_at_demus-online.de (Oliver Demus)

> > wrote:

> >

> > >mail_conn := utl_smtp.open_connection('smtp.webaddress.de, 25);

> >

> > The ' in this line is unbalanced.

> > Also you need to have a SMTP server running.

> >

> >

> > Sybrand Bakker, Senior Oracle DBA

> >

> > To reply remove -verwijderdit from my e-mail address

Received on Thu Jan 30 2003 - 12:19:49 CST