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
Received on Tue Feb 21 2006 - 11:15:30 CST