Re: Problems, to get utlsmtp up and running

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 Mon Jan 27 2003 - 11:37:57 CST