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.
________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Ujang Jaenudin Sent: Monday, March 13, 2006 11:19 AM To: [email protected] Subject: [indo-oracle] trigger after logon on database dear all, saya coba buat trigger after logon on database, dan procedure untuk kill it's session kalo dia pake toad,sqlplus atau third party lainnya except oracle form/report. permasalahannya kenapa trigger after logon on database tidak ter-fire ya..... login as monthend: CREATE OR REPLACE PROCEDURE x_db_start IS cid INTEGER; ret INTEGER; sqltxt VARCHAR2(150); v_prg VARCHAR2(150); v_sid number; v_serial number; BEGIN --alter system kill session p_sid,p_serial; select f_sid, f_serial, f_program into v_sid, v_serial, v_prg from x_logon_tbl where rownum<=1; if v_prg is not null then cid := DBMS_SQL.OPEN_CURSOR; sqltxt := 'alter system kill session '||''''||v_sid||','||v_serial||''''; DBMS_SQL.PARSE(cid, sqltxt, dbms_sql.v7); DBMS_OUTPUT.PUT_LINE(sqltxt); ret := DBMS_SQL.EXECUTE(cid); DBMS_SQL.CLOSE_CURSOR(cid); DBMS_OUTPUT.PUT_LINE('Sukses'); end if; EXCEPTION WHEN OTHERS THEN --DBMS_SQL.CLOSE_CURSOR(cid); DBMS_OUTPUT.PUT_LINE('Gagal : '||SQLERRM ); END; / login as sys: create or replace trigger trg_logon_db after logon on database begin delete from monthend.x_logon_tbl; insert into monthend.x_logon_tbl(f_sid, f_serial, f_program) select sid,serial#,module from v$session where audsid = sys_context('USERENV', 'SESSIONID'); commit; monthend.x_db_start; end; / regards --ujang http://blog.faaza.info 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/
