Hallo... Saya pernah membahas dan memberi contoh tentang memanggil shell script dari SQL dan PL/SQL. Silahkan lihat di sini
http://rohmad.net/2008/07/24/menjalankan-os-command-atau-shell-script-dari-plsql/ Salam, Rohmad --- In [email protected], hendra chen <[EMAIL PROTECTED]> wrote: > > 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] >
