-
Hi..
I have written a simple trigger on log_logon event
create or replace trigger log_logon
after logon on database
when (user = 'cicpa')
declare
a varchar2(50);
begin
a:='BAKSHI WELL COMES YOU';
dbms_output.PUT_LINE('a');
end;
but i am not getting the message after login to sql plus
can any one provide me a solution
thanx and regards,,
bakshi
-
Hi Kusumakar,
If you could able login successfully, the trigger might be getting executed. Try to edit login.sql/glogin.sql file to include sqlplus setting "serveroutput on". Hope this will work.
