Home » SQL & PL/SQL » SQL & PL/SQL » Trigger to display a message at Logon
Trigger to display a message at Logon [message #36594] Wed, 05 December 2001 11:44 Go to next message
JOHN
Messages: 182
Registered: April 1998
Senior Member
Hi:

I was wondering if it is possible to have a message displayed when a user logs into SQL+ using a trigger. I have seen after logon triggers, but they always insert a value to a dummy table. I have tried DBMS_OUTPUT to print the line, ensuring the serveroutput is on, but the message does not print.
Your help is appreciated.

Thanks

----------------------------------------------------------------------
Re: Trigger to display a message at Logon [message #36648 is a reply to message #36594] Mon, 10 December 2001 02:17 Go to previous message
Satish Shrikhande
Messages: 167
Registered: October 2001
Senior Member
Trigger log on -
They can be used to run any appropriate initialisation routines such as altering the CURRENT_SCHEMA or turning on/off debugging and/or tracing options.

----------------------------------------------------------------------
Previous Topic: DBMS_SQL.DEFINE_COLUMN error!
Next Topic: how to pass date in sp as parameter
Goto Forum:
  


Current Time: Thu Mar 28 20:51:29 CDT 2024