Re:utl_smtp query

From: <dgoulet_at_vicr.com>
Date: Tue, 31 Jul 2001 08:18:42 -0700
Message-ID: <F001.0035A1CC.20010731072257@fatcity.com>

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" <oqij4ngfcrweuh001_at_sneakemail.com>
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.

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META content="MSHTML 5.00.2920.0" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hi again everybody, </FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>    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 :(</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>    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#100 1075">http://www-wnt.gsi.de/oragsidoc/doc_816/server.816/a76936/utl_smt6.htm#100 1075</A>)
almost exaclty, so there's  a 98% level of plagiarism :)</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>    The following code
:</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2><B><FONT color=#000000 size=1>CREATE</B> <B>OR</B>
<B>REPLACE</B> <B>PROCEDURE</B> send_mail (sender <B>IN</B> <B>VARCHAR2</B>,
<BR>recipient <B>IN</B> <B>VARCHAR2</B>, <BR>message <B>IN</B>
<B>VARCHAR2</B>)<BR><B>IS</B><BR>mailhost <B>VARCHAR2</B>(</FONT><FONT
color=#0000f0 size=1>30</FONT><FONT color=#000000 size=1>) := </FONT><FONT color=#0000f0 size=1>'mail'</FONT><FONT color=#000000 size=1>;<BR>mail_conn utl_smtp.connection;<BR><BR><B>BEGIN</B><BR>mail_conn := utl_smtp.open_connection(mailhost, </FONT><FONT color=#0000f0 size=1>25</FONT><FONT color=#000000 size=1>);<BR>utl_smtp.helo(mail_conn, mailhost);<BR>utl_smtp.mail(mail_conn, sender);<BR>utl_smtp.rcpt(mail_conn, recipient);<BR>utl_smtp.data(mail_conn, message);<BR>utl_smtp.quit(mail_conn);<BR><B>END</B>;</FONT></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>    Returns this error
:</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>    PLS-00201: identifier
'UTL_SMTP.CONNECTION' must be declared</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>    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.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Thanks guys and girls,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Michael.</FONT></DIV>
<DIV> </DIV></BODY></HTML>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: dgoulet_at_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_at_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).

Received on Tue Jul 31 2001 - 10:18:42 CDT