Apa sudah cek column module di v$session ? Kalo menurut saya sebaiknya ambil column 'program'. Catatan : raise_application_error tidak berlaku untuk system atau sysdba. frans
________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Ujang Jaenudin Sent: Monday, March 13, 2006 1:55 PM To: [email protected] Subject: Re: [indo-oracle] trigger after logon on database frans, tetep aja, ke tabel masuk, tapi kok raise applicationnya gak ngaruh apa-apa euy....tetep aja bisa connect. anehnya kalo saya taroh commit setelah insert into.... malah recordnya gak ada...hm..... speks: OS w2k sp4 10g r1 create or replace trigger trg_logon_db after logon on database declare v_module varchar2(100); v_sid numeric(30,0); v_serial numeric(30,0); begin select nvl(module,'@@9@@'),sid,serial# into v_module,v_sid,v_serial from v$session where audsid = sys_context('USERENV', 'SESSIONID'); delete from monthend.x_logon_tbl; insert into monthend.x_logon_tbl(f_sid, f_serial, f_program) values(v_sid,v_serial,v_module); if v_module != '@@9@@' then RAISE_APPLICATION_ERROR(-20279,'Not Allowed'); end if; end; regards --ujang http://blog.faaza.info ----- Original Message ----- From: "Frans. Diary Mazhar" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Monday, March 13, 2006 12:39 PM Subject: RE: [indo-oracle] trigger after logon on database > Menurut saya sebenarnya trigger ini fired, cuma karena waktu baru > connect, table x_logon_tbs masih kosong jadi lari ke exception. > Saran saya ganti pakai v$session untuk memeriksa program yg dijalankan, > karena lebih aman dan tidak bisa dimodifikasi. > Lalu tidak bisa pakai alter system kill session. Cukup RAISE application > error saja. > > frans. Send instant messages to your online friends http://asia.messenger.yahoo.com -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.lizt.org (NEW) ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.com SPONSORED LINKS Membership database software <http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Mem bership+database+software&w2=Database+mortgage+software&w3=Pda+database+ software&w4=Database+management+software&w5=Oracle+database+administrati on&w6=Oracle+database+management&c=6&s=195&.sig=eDDh4hKVCztlkTEeYzirSg> Database mortgage software <http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Membe rship+database+software&w2=Database+mortgage+software&w3=Pda+database+so ftware&w4=Database+management+software&w5=Oracle+database+administration &w6=Oracle+database+management&c=6&s=195&.sig=hXxg74XuhXSzegVx-t1xkA> Pda database software <http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Membership +database+software&w2=Database+mortgage+software&w3=Pda+database+softwar e&w4=Database+management+software&w5=Oracle+database+administration&w6=O racle+database+management&c=6&s=195&.sig=roR_Z1cY1-GOzqzt3GgyUw> Database management software <http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Mem bership+database+software&w2=Database+mortgage+software&w3=Pda+database+ software&w4=Database+management+software&w5=Oracle+database+administrati on&w6=Oracle+database+management&c=6&s=195&.sig=qVd58SCSnEG4iKPrZDnKTA> Oracle database administration <http://groups.yahoo.com/gads?t=ms&k=Oracle+database+administration&w1=M embership+database+software&w2=Database+mortgage+software&w3=Pda+databas e+software&w4=Database+management+software&w5=Oracle+database+administra tion&w6=Oracle+database+management&c=6&s=195&.sig=HnkpKGBwHtP2yh9OvVaS3Q > Oracle database management <http://groups.yahoo.com/gads?t=ms&k=Oracle+database+management&w1=Membe rship+database+software&w2=Database+mortgage+software&w3=Pda+database+so ftware&w4=Database+management+software&w5=Oracle+database+administration &w6=Oracle+database+management&c=6&s=195&.sig=8YpXzkCJ2hlCDM-NY94dXQ> ________________________________ YAHOO! GROUPS LINKS * Visit your group "indo-oracle <http://groups.yahoo.com/group/indo-oracle> " on the web. * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> . ________________________________ [Non-text portions of this message have been removed] -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.lizt.org (NEW) ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
