Re: system trigger question


stevedhow...@xxxxxxxxx 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

.

Relevant Pages

  • Re: => Unorthodox DB Updates - Trigger order
    ... But if you have any suggestions for trigger ordering it ... The last trigger is fired on each update of SupplierOrder. ... collectionMovementID into the SupplierOrder rows in the second trigger ... a second statement if it is really necessary. ...
    (microsoft.public.sqlserver.mseq)
  • Re: Global Variables?
    ... Why have a second trigger do this? ... first trigger and pass the needed info into it? ... into a second trigger I've ...
    (microsoft.public.sqlserver.programming)
  • Re: How to solve trigger side effects
    ... Each trigger belongs to a certain table. ... So I can deactivate the second trigger, ... The package consists of a local variable, ...
    (comp.databases.oracle.misc)
  • How to solve trigger side effects
    ... Each trigger belongs to a certain table. ... changes data in that table having the other trigger. ... So I can deactivate the second trigger, ...
    (comp.databases.oracle.misc)