trigger error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: trigger error

  1. #1
    Join Date
    Jan 2001
    Posts
    10

    Thumbs up

    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

  2. #2
    Join Date
    Feb 2001
    Location
    Bangalore, India
    Posts
    109
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width