Subject | Re: problem with insert/commit moment |
---|---|
Author | df_nina |
Post date | 2008-04-16T15:23:13Z |
Hi!
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
> The simplest solution is to leave blank parameter 'NOW' and defineinto your
> log table the default value as 'NOW' for "ora" field.This way youget 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