utl_smtp query

[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#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.