jika memang ada masalah dalam package UTL_MAIL, gunakan saja tools OS untuk kirim email,
saya sih lebih suka gunakan OS punya,krn jika DB down, saya bs tau, krn email nya tetap terkirim. --- On Tue, 29/7/08, Izzudin Hanafie <[EMAIL PROTECTED]> wrote: From: Izzudin Hanafie <[EMAIL PROTECTED]> Subject: Re: [indo-oracle] Kirim e-mail dengan UTL_MAIL To: [email protected] Date: Tuesday, 29 July, 2008, 4:33 PM 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] com> wrote: From: Bayu Kurniawan R <[EMAIL PROTECTED] com> Subject: [indo-oracle] Kirim e-mail dengan UTL_MAIL To: indo-oracle@ yahoogroups. com 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] Get your new Email address! Grab the Email name you've always wanted before someone else does! http://mail.promotions.yahoo.com/newdomains/sg/ [Non-text portions of this message have been removed]
