From dgoulet@vicr.com Tue, 31 Jul 2001 08:18:42 -0700 From: dgoulet@vicr.com Date: Tue, 31 Jul 2001 08:18:42 -0700 Subject: Re:utl_smtp query Message-ID: MIME-Version: 1.0 Content-Type: text/plain Mike, Check out notes 130785.1 and 105472.1 on MetaLink. I followed there instructions and it worked first time. NOTE: After you run $ORACLE_HOME/javam/install/initjvm.sql you need to manually run $ORACLE_HOME/rdbms/admin/initplsj.sql. It's a listed bug. Dick Goulet ____________________Reply Separator____________________ Author: "Michael" Date: 7/31/2001 2:25 AM Hi again everybody, Since you were all so helpful last time, I'm going to bug you again. I've been fiddling with utl_smtp recently, trying to get the silly thing working without having to copy off an example. Sadly, in the end, I've had to copy :( I'm ripping off the example code from the orafaq site on utl_smtp (http://www-wnt.gsi.de/oragsidoc/doc_816/server.816/a76936/utl_smt6.htm#1001075) almost exaclty, so there's a 98% level of plagiarism :) The following code : CREATE OR REPLACE PROCEDURE send_mail (sender IN VARCHAR2, recipient IN VARCHAR2, message IN VARCHAR2) IS mailhost VARCHAR2(30) := 'mail'; mail_conn utl_smtp.connection; BEGIN mail_conn := utl_smtp.open_connection(mailhost, 25); utl_smtp.helo(mail_conn, mailhost); utl_smtp.mail(mail_conn, sender); utl_smtp.rcpt(mail_conn, recipient); utl_smtp.data(mail_conn, message); utl_smtp.quit(mail_conn); END; Returns this error : PLS-00201: identifier 'UTL_SMTP.CONNECTION' must be declared I have checked, and my db is installed with jserver. That's about all I can get about the error. _very_ novice PL/SQL developer here, and I'd love some feedback. Thanks guys and girls, Michael.
Hi again everybody,
 
    Since you were all so helpful last time, I'm going to bug you again. I've been fiddling with utl_smtp recently, trying to get the silly thing working without having to copy off an example. Sadly, in the end, I've had to     copy :(
 
    I'm ripping off the example code from the orafaq site on utl_smtp (http://www-wnt.gsi.de/oragsidoc/doc_816/server.816/a76936/utl_smt6.htm#100 1075) almost exaclty, so there's  a 98% level of plagiarism :)
 
    The following code :
 
CREATE OR REPLACE PROCEDURE send_mail (sender IN VARCHAR2,
recipient IN VARCHAR2,
message IN VARCHAR2)
IS
mailhost VARCHAR2(30) := 'mail';
mail_conn utl_smtp.connection;

BEGIN
mail_conn := utl_smtp.open_connection(mailhost, 25);
utl_smtp.helo(mail_conn, mailhost);
utl_smtp.mail(mail_conn, sender);
utl_smtp.rcpt(mail_conn, recipient);
utl_smtp.data(mail_conn, message);
utl_smtp.quit(mail_conn);
END;
 
    Returns this error :
 
    PLS-00201: identifier 'UTL_SMTP.CONNECTION' must be declared
 
    I have checked, and my db is installed with jserver. That's about all I can get about the error. _very_ novice PL/SQL developer here, and I'd love some feedback.
 
Thanks guys and girls,
 
Michael.
 
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: dgoulet@vicr.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).