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" <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
