After Logon Trigger Not Firing
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: After Logon Trigger Not Firing

Threaded View

  1. #1
    Join Date
    Apr 2002
    Location
    Phoenix, AZ
    Posts
    175

    After Logon Trigger Not Firing

    I am on Oracle 9.2. My actual goal is to trace certain SCHEMA.
    In the script below, both insert and execute immediate do not work, independently or together. The Schema name is TEST.

    Am I missing something? Test has DBA Privs. Also there is some thing more that is happening. When I put any line in the trigger (any valid line at all) except NULL, I get a trace file for about 700 bytes. But further actions in the same session are not getting recorded in the Trace File.

    CREATE OR REPLACE TRIGGER TEST.TEST_TRIGGER
    AFTER LOGON
    ON TEST.SCHEMA
    DECLARE
    tmpVar NUMBER;
    BEGIN
    EXECUTE IMMEDIATE 'ALTER SESSION SET SQL_TRACE=TRUE';
    -- and/or
    INSERT INTO testtab VALUES (1010);
    COMMIT;
    END;
    Last edited by patnams; 10-19-2004 at 04:27 PM.
    Sridhar R Patnam

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