Re: system trigger question

stevedhow..._at_gmail.com wrote:
> What is _system_trig_enabled set to?
>
> SELECT a.ksppinm || ' '|| b.ksppstvl || ' ' || c.ksppstvl
> FROM x$ksppi a,
> x$ksppcv b,
> x$ksppsv c
> WHERE a.indx = b.indx
> AND a.indx = c.indx
> AND a.ksppinm like '%system_trig%'
> /
>
> Regards,
>
> Steve

The problem isn't with _system_trig_enabled, it's with the original code as I've noted. The first trigger is missing:

end;
/

so it isn't recognised as a completed PL/SQL trigger. The second trigger selects non-existent columns from V$SESSION (last_program,last_module), thus it fails and no records are found in stats$user_log. Unfortunately Oracle has no apparent sanity check on selects in system triggers so the original code for the second trigger compiles error-free. Only when the trigger is fired and no updates appear does the issue surface.

David Fitzjarrell Received on Tue Apr 18 2006 - 19:50:19 CDT