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
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/
