Re: Logon trigger questions

Sorry, I don't have a 9.2.0.5 instance available to test with. I will say that with 10.2.0.1, the exception below was written to the alert log when my logon trigger had the folllowing:

create or replace trigger logon_test
  after logon on database
begin
  execute immediate 'alter session set foobar = false'; end;
/

Mon Apr 03 15:37:48 2006
Errors in file
c:\oracle\product\10.2.0\admin\test10g\udump\test10g_ora_5244.trc:

ORA-00604: error occurred at recursive SQL level 1
ORA-02248: invalid option for ALTER SESSION
ORA-06512: at line 2

1. It should, with EXECUTE IMMEDIATE. I don't know if 9.2.0.5 automatically wrote to the alert log (I don't *think* it did).
2. begin sys.dbms_system.ksdwrt(2, 'My message'); end;
   /
   
3. Why would it become invalid? Yes, or set _system_trig_enabled = false in the instance initialization file.

Regards,

Steve Received on Mon Apr 03 2006 - 14:45:34 CDT