"Daniel Rail" <daniel@...> wrote in message
news:<553992791.20060618102948@...>...

>
> CURRENT_TIMESTAMP will be consistent for the duration of the
> transaction. So in example, if the transaction was started 2 hours
> ago, that will be the value of CURRENT_TIMESTAMP.

Nope. CURRENT-variables are consistent for the duration of the active
request (aka statement). A procedure/trigger is considered being a single
request.


Dmitry