| After Logon Produces No Error even with Raise_application_error [message #39231] |
Thu, 27 June 2002 22:40  |
Tony Ho
Messages: 1
Registered: June 2002
|
Junior Member |
|
|
Hi,
I created a script to test on the after logon trigger as follow :
create or replace trigger SYS.T_CONNECT_RESTRICTIONS_T
AFTER LOGON ON DATABASE
DECLARE
BEGIN
RAISE_APPLICATION_ERROR (-20999, 'test' );
EXECUTE IMMEDIATE 'DISCONNECT';
END;
After successful compilation, i used sqlplus.exe to log into the database instance. I discovered that the raise_application_error was executed but the strange thing is that i can still get myself connected in sqlplus. I did a select statement and the connection is intact.
Any assistance/advice is greatly appreciated.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
