Problems, to get utlsmtp up and running

Newbie needs some help:

I am running Oracle 8.1.7 on WIN2000

I did the following:
Installed $ORACLE_HOME/javavm/install/initjvm.sql then $ORACLE_HOME/rdbms/admin/initplsj.sql after that the utlsmtp.sql

Then I restarted the database and run the following with the command exec send_mail3;

create or replace PROCEDURE SEND_MAIL3
 is

crlf VARCHAR2(2):= CHR( 13 ) || CHR( 10 ); mesg VARCHAR2(4000);
mail_conn UTL_SMTP.CONNECTION;
cc_recipient VARCHAR2(50) default 'email-address';

BEGIN mail_conn := utl_smtp.open_connection('smtp.webaddress.de, 25);

utl_smtp.helo(mail_conn, 'webaddress.de');
utl_smtp.mail(mail_conn, 'email-address');
utl_smtp.rcpt(mail_conn, 'email-address');
utl_smtp.rcpt(mail_conn, 'email-address');

mesg:= 'Date: ' || TO_CHAR( SYSDATE, 'dd Mon yy hh24:mi:ss' ) || crlf ||
'From: ' || 'email-address'|| crlf ||
'To: ' || 'email-address'|| crlf ||
'Cc: ' || 'email-address'|| crlf ||

--'Bcc: ' || bcc_recipient || crlf ||
'Subject: ' || 'Test Subject' || crlf;

mesg:= mesg || '' || crlf || 'Bodytext';

utl_smtp.data(mail_conn, mesg);
utl_smtp.quit(mail_conn);

EXCEPTION
WHEN OTHERS THEN
dbms_output.put_line(sqlerrm);

END;
/

This returns with: PL/SQL procedure successfully completed. But I recieved no email, do I have to make an entry in the init.ora?

Can anybody help? Received on Sun Jan 26 2003 - 14:42:34 CST