Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Email form Oracle 9i

Re: Email form Oracle 9i

From: noone <noone_at_nowhere.com>
Date: Tue, 21 Feb 2006 17:41:22 GMT
Message-ID: <6hIKf.32925$Jd.5369@newssvr25.news.prodigy.net>


epipko_at_gmail.com wrote:
> Hi all,
> I am trying to test email from Oracle 9i and getting an error. What
> could I do to resolve it, please?
> --------------------
> SQL> DECLARE
> 2 l_mailhost VARCHAR2(64) := '165.125.1.2';
> 3 l_from VARCHAR2(64) := 'from_at_me.com';
> 4 l_to VARCHAR2(64) := 'to_at_me.com';
> 5 l_mail_conn UTL_SMTP.connection;
> 6 BEGIN
> 7 l_mail_conn := UTL_SMTP.open_connection(l_mailhost, 25);
> 8 UTL_SMTP.helo(l_mail_conn, l_mailhost);
> 9 UTL_SMTP.mail(l_mail_conn, l_from);
> 10 UTL_SMTP.rcpt(l_mail_conn, l_to);
> 11 UTL_SMTP.data(l_mail_conn, 'Single string message.' || Chr(13));
> 12 UTL_SMTP.quit(l_mail_conn);
> 13 END;
> 14 /
> l_mail_conn UTL_SMTP.connection;
> *
> ERROR at line 5:
> ORA-06550: line 5, column 17:
> PLS-00201: identifier 'UTL_SMTP' must be declared
> ORA-06550: line 5, column 17:
> PL/SQL: Item ignored
> ORA-06550: line 7, column 3:
> PLS-00320: the declaration of the type of this expression is incomplete
> or malformed
> ORA-06550: line 7, column 3:
> PL/SQL: Statement ignored
> ORA-06550: line 8, column 17:
> PLS-00320: the declaration of the type of this expression is incomplete
> or malformed
> ORA-06550: line 8, column 3:
> PL/SQL: Statement ignored
> ORA-06550: line 9, column 17:
> PLS-00320: the declaration of the type of this expression is incomplete
> or malformed
> ORA-06550: line 9, column 3:
> PL/SQL: Statement ignored
> ORA-06550: line 10, column 17:
> PLS-00320: the declaration of the type of this expression is incomplete
> or malformed
> ORA-06550: line 10, column 3:
> PL/SQL: Statement ignored
> ORA-06550: line 11, column 17:
> PLS-00320: the declaration of the type of this expression is incomplete
> or malformed
> ORA-06550: line 11, column 3:
> PL/SQL: Statement ignored
> ORA-06550: line 12, column 17:
> PLS-0032
> --------------------------
> Thanks,
> Eugene
>

Make sure you installed your jserver correctly: do a google search for ORA-06550 utl_smtp

There are many examples of problems that cause this error. Received on Tue Feb 21 2006 - 11:41:22 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US