usage of AFTER LOGON DATABASE trigger

[praveenc]

plse help me how to use

AFTER LOGON DATABASE trigger


for chnging NLs settings in the java application

[debasisdas]

try this sample code

create or replace trigger mytrig1
after logon on scott.schema
declare
a char(3);
begin
select to_char(sysdate,'dy') into a from dual;
if a in('sun','sat') then
Raise_application_error(-20004,'Cannot LOGIN today');
end if;
end;