Saya telah berhasil menginstall UTL_MAIL di Oracle 10XE pada Redhat
EL5, dengan menggunakan perintah :
SQL> connect sys/password as sysdba
Connected.
SQL> @$ORACLE_HOME/rdbms/admin/utlmail.sql
Package created.
Synonym created.
SQL> @$ORACLE_HOME /rdbms/admin/prvtmail.plb
Package body created.
No errors.
SQL> alter system set smtp_out_server = '<ip-address:port' scope=Both;
Kemudian untuk mengetes e-mail dengan menggunakan perintah berikut :
begin
utl_mail.send(
sender => '[EMAIL PROTECTED]',
recipients => ' [EMAIL PROTECTED]',
subject => 'Testing utl_mail',
message => 'The receipt of this email means'||
' that shutting down the database'||
' works for UTL_MAIL '
);
end;
/
Dan hasilnya :
ERROR at line 1:
ORA-29278: SMTP transient error: 421 Service not available
ORA-06512: at "SYS.UTL_SMTP", line 21
ORA-06512: at "SYS.UTL_SMTP", line 97
ORA-06512: at "SYS.UTL_SMTP", line 139
ORA-06512: at "SYS.UTL_MAIL", line 405
ORA-06512: at "SYS.UTL_MAIL", line 594
ORA-06512: at line 2
Please help
