At 04:21 PM 4/22/03 +0400, Nickolay Samofatov wrote:

>Hi, Jim,
>
> > At 10:02 AM 4/22/03 +0200, Martijn Tonies wrote:
>
> >>Which reminds me - Oracle also has triggers that fire after each statement
> >>instead of each row... Also quite a nice addition :)
>
> > How are used? I've never understood what they're good for.
>
>Simple. Oracle forbids access to a table for which trigger is fired
>from row triggers. To do some useful work you need to create temporary
>table in PRE- statement trigger, fill it with work you want to do in
>row triggers and actually do the work in POST- statement trigger.

Sounds less like a feature than a workaround for an Oracle bug.

Jim Starkey