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

Home -> Community -> Mailing Lists -> Oracle-L -> utl_smtp query

utl_smtp query

From: Michael <oqij4ngfcrweuh001_at_sneakemail.com>
Date: Tue, 31 Jul 2001 02:21:04 -0700
Message-ID: <F001.00359BC4.20010731022550@fatcity.com>

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 (<A
href="http://www-wnt.gsi.de/oragsidoc/doc_816/server.816/a76936/utl_smt6.htm#1001075">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)ISmailhost VARCHAR2(<FONT
color=#0000f0 size=1>30) := <FONT
color=#0000f0 size=1>'mail';mail_conn
utl_smtp.connection;BEGINmail_conn :=
utl_smtp.open_connection(mailhost, <FONT color=#0000f0 size=1>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.
 
Received on Tue Jul 31 2001 - 04:21:04 CDT

Original text of this message

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