Subject Re: problem with insert/commit moment
Author df_nina
Hi!

> The simplest solution is to leave blank parameter 'NOW' and define
into your
> log table the default value as 'NOW' for "ora" field.This way you
get the
> time when transaction is committed!

thanks for your suggestion, I try to do it, but it doesn't work. I set
the default value as 'NOW' and in the trigger I don't set any values,
but it keeps the insert moment, not the commit (I think that it's
because the insert in the A table and the insert in the log table are
in the same transaction, aren't they?)

Best regards,
Nina