ya tergantung OS yang bapak gunakan. misalnya saya gunakan OS HPUX, ya saya setting dl n gunakan script shell untuk mengirimkan mail yang isi nya saya ambil dari DB. dari sisi DB ya kita gunakan query apa yang mau kita keluarkan, gunakan aja DBMS_OUTPUT untuk menampung hasil query yang mau di kirim, atau spool , dan nanti isi nya bs di kirim berupa attach mail.
--- On Thu, 31/7/08, agus purwanto <[EMAIL PROTECTED]> wrote: From: agus purwanto <[EMAIL PROTECTED]> Subject: Re: [indo-oracle] Kirim e-mail dengan UTL_MAIL To: [email protected] Date: Thursday, 31 July, 2008, 9:46 AM caranya gimana ya pak kalo dari OS ? ----- Original Message ---- From: hendra chen <[EMAIL PROTECTED] com.sg> To: indo-oracle@ yahoogroups. com Sent: Thursday, July 31, 2008 9:42:41 AM Subject: Re: [indo-oracle] Kirim e-mail dengan UTL_MAIL 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 <izzudin_aq@ yahoo. com> wrote: From: Izzudin Hanafie <izzudin_aq@ yahoo. com> Subject: Re: [indo-oracle] Kirim e-mail dengan UTL_MAIL To: indo-oracle@ yahoogroups. com 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] [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]
