Re: how to recognize if my trigger is fireing ?

Martin Schack wrote:

>hi,
>
>i've written a pl/sql procedure, that gets called inside a trigger (after
>update, for each row) the trigger is valid, and active !
>
>if i call the procedure manually it works fine, but from within the trigger
>nothing happens.
>how can i control if the trigger really fires ??
>
>thanks for help
>
>Martin
>
>
>
>
CREATE OR REPLACE PROCEDURE test (

PRAGMA AUTONOMOUS_TRANSACTION; BEGIN
   INSERT INTO monitor VALUES (SYSDATE);    COMMIT;
END;
/

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)