Re: triggers and commit

In article <D1u6In.zo_at_sybase.com> pcoll_at_sybase.com writes:

> Lets move into the real world - I have a debit/credit transaction
> and perform the debit from one account, but find the the account
> to be credited does not exist. Rollback would be nice, and the
> natural way to do it. Having taken 7 years to get triggers, I guess
> another 7 should make them work.

You don't need to rollback; if the trigger is done right, the insert itself will fail. And if the insert fails, by default the insert is not done. It never happens. There is really no need to rollback.

Of course, from a Sybase point of view... :)

--
      ___
     (o o)
+-oo0-\_/-0oo---------------------------------------------------------------+
| Alvin Law .. Project Leader, Applications Division ... Oracle Corporation |
|  Email: alaw_at_us.oracle.com ..... Voice: 415.506.8317 . Fax: 415.506.7299  |
+---------------------------------------------------------------------------+

ORA-03113: end-of-file on communication channel