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
