Mas Bayu, apakah masalah tersebut sudah solve...?. Bila memang sudah, mohon sharingnya..:D. Saya juga mengalami masalah serupa ketika akan mengaktifkan package UTL_MAIL. Barangkali ada rekan's yang pernah mengalami hal tersebut..?.
Mohon informasinya, Thanks Izzudin Hanafie --- On Thu, 7/24/08, Bayu Kurniawan R <[EMAIL PROTECTED]> wrote: From: Bayu Kurniawan R <[EMAIL PROTECTED]> Subject: [indo-oracle] Kirim e-mail dengan UTL_MAIL To: [email protected] Date: Thursday, July 24, 2008, 7:48 AM 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 => 'gjwilliams01@ yahoo.com', recipients => ' gjwilliams01@ yahoo.com', 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 [Non-text portions of this message have been removed]
