Re: Need Help with Trigger

PKelley772 wrote:
>
> Gerry Douglas <gdouglas_at_mailhost.wlc.com> writes about problems creating
> and testing a trigger.
>
> Simple debugging/trace statements can inserted in plsql scripts and seen
> in sqlplus if you do the following
>
> 1. in your trigger, include calls to dbms_output.put_line, e.g.,
>
> dbms_output.put_line('at start of my.trigger');
>
> 2. before initiating a transaction against the table where the trigger
> resides,
> do the following:
>
> sqlplus > set serveroutput on
>
> If your trigger fires, you'll see 'at start of my.trigger' displayed on
> the screen.

But only after the trigger is through executing.

-- 
_________________________________________________
Robert C. Nix
Oracle Tools Support
rnix_at_us.oracle.com

DISCLAIMER:
The thoughts, opinions, remarks, suggestions, ...
expressed herein are my own and in no way should
be taken as a statement from Oracle Corporation.
I am NOT the voice of Oracle (not even close!).