Re: Problems, to get utlsmtp up and running

From: Guido Konsolke <Guido.Konsolke_at_triaton.com>
Date: Tue, 28 Jan 2003 08:28:29 +0100
Message-ID: <1043738816.927049@news.thyssen.com>

"Oliver Demus" schrieb...
> 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

Hi Oliver,

I don't know how you get this 'TEST.UTL_SMTP' message. The utl_smtp-package should be installed / owned by user SYS. Maybe that's your problem.

hth,
Guido Received on Tue Jan 28 2003 - 01:28:29 CST