dulu saya pernah liat script sql buat panggil script shell, cuma saya sudah lupa gimana command nya, seperti nya menggunakan function sql. mungkin ada yang bisa bantu bagaimana script sql buat panggil script shell ?
tp menurut saya, untuk kasus bapak, sebaik nya gunakan script sql saja untuk mengirim email nya, karena bapak memakai trigger dari table. --- On Thu, 31/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: Thursday, 31 July, 2008, 11:34 AM Berarti shell scriptnya tersebut dijalankan menggunakan scheduler OS (crontab or scheduled task) yaa..?. Bagaimana bila shell script tersebut jalan berdasarkan trigger dari aplikasi sendiri..?. Saya menggunakan fasilitas UTL_MAIL tersebut karena notifikasi emailnya based on trigger dari aplikasi. Jadi bila ada perubahan data, maka otomatis akan mengirim email ke orang2 tertentu. CMIIW, Izzudin Hanafie --- On Thu, 7/31/08, hendra chen <[EMAIL PROTECTED] com.sg> wrote: From: hendra chen <[EMAIL PROTECTED] com.sg> Subject: Re: [indo-oracle] Kirim e-mail dengan UTL_MAIL To: indo-oracle@ yahoogroups. com Date: Thursday, July 31, 2008, 12:25 AM kalo dari OS, cara nya bukan dari DB yang panggil script shell nya, tapi script shell yang panggil script DB. biasa nya saya pakai command begini : echo "panggil script DB .." su - oracle << EOF sqlplus <user>/<passwd> @<sid> @<nama_script_ db>.sql exit; EOF echo "end process." nanti setelah ini tambahin script untuk kirim mailnya. --- On Thu, 31/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: Thursday, 31 July, 2008, 11:02 AM Sekarang sudah bisa...:). Ternyata service SMTP di database servernya belum hidup, makanya muncul error message seperti dibawah. Pak Hendra, trigger dari DB untuk memanggil shell script template email itu sendiri bagaimana yaa bila mengunakan OS ..?. Regard's Izzudin Hanafie --- On Wed, 7/30/08, hendra chen <h3ndr4ch3n@ yahoo. com.sg> wrote: From: hendra chen <h3ndr4ch3n@ yahoo. com.sg> Subject: Re: [indo-oracle] Kirim e-mail dengan UTL_MAIL To: indo-oracle@ yahoogroups. com Date: Wednesday, July 30, 2008, 10:55 PM 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 <purwanto_ags@ yahoo.com> wrote: From: agus purwanto <purwanto_ags@ yahoo.com> Subject: Re: [indo-oracle] Kirim e-mail dengan UTL_MAIL To: indo-oracle@ yahoogroups. com Date: Thursday, 31 July, 2008, 9:46 AM caranya gimana ya pak kalo dari OS ? ----- Original Message ---- From: hendra chen <h3ndr4ch3n@ yahoo. 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] [Non-text portions of this message have been removed] New Email addresses available on Yahoo! Get the Email name you've always wanted on the new @ymail and @rocketmail. Hurry 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]
