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 -> Email form Oracle 9i

Email form Oracle 9i

From: <epipko_at_gmail.com>
Date: 21 Feb 2006 09:15:30 -0800
Message-ID: <1140542130.101159.136580@z14g2000cwz.googlegroups.com>


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

Original text of this message

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