Connecting Tech Pros Worldwide Forums | Help | Site Map
bytes > topic > oracle > answers

usage of AFTER LOGON DATABASE trigger

Newbie
  
Join Date: Oct 2009
Posts: 1
#1: Oct 21 '09
plse help me how to use

AFTER LOGON DATABASE trigger


for chnging NLs settings in the java application
best answer - posted by debasisdas
try this sample code
Expand|Select|Wrap|Line Numbers
  1. create or replace trigger mytrig1
  2. after logon on scott.schema
  3. declare
  4. a char(3);
  5. begin
  6. select to_char(sysdate,'dy') into a from dual;
  7. if a in('sun','sat') then
  8. Raise_application_error(-20004,'Cannot LOGIN today');
  9. end if;
  10. end;
  11.  



debasisdas's Avatar
Moderator
  
Join Date: Dec 2006
Location: Bangalore ,India
Posts: 7,508
#2: Oct 21 '09

re: usage of AFTER LOGON DATABASE trigger

try this sample code
Expand|Select|Wrap|Line Numbers
  1. create or replace trigger mytrig1
  2. after logon on scott.schema
  3. declare
  4. a char(3);
  5. begin
  6. select to_char(sysdate,'dy') into a from dual;
  7. if a in('sun','sat') then
  8. Raise_application_error(-20004,'Cannot LOGIN today');
  9. end if;
  10. end;
  11.  
Reply

Tags
nls_settings_logontrigger

« previous question | next question »

Similar Oracle Database bytes

/bytes/development

/bytes/it

Forums
Visit our community forums for general discussions and latest on Bytes

Our staff and community areas have moved to bytes.com/forums/

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,414 network members.

dev questions:
algorithms | asp | asp.net | c/c++ | coldfusion | c# | flash | html/css | java | javascript |
mobile dev | .net | perl | php | python | ruby | software dev | vb.net | visual basic | xml
it questions:
access | apache | careers | db2 | iis | macosx | mysql | networking | oracle | postgresql | sql server | unix | windows

About Bytes | Copyright 1995-2009 BYTES. All rights Reserved