Thanks a lot Sayan. Your explanation makes perfect sense. I was able to
reproduce the scenario by simply increasing the length of the CHAR column
and leaving the length semantics as is (e.g. from 1 BYTE to 2 BYTE).
Perhaps a good interview question - "can table ddl ever cause a dml trigger
to fire?".
Regards,
Steve
--
------------------------------------------------------------------
This email is intended solely for the use of the addressee and may
contain information that is confidential, proprietary, or both.
If you receive this email in error please immediately notify the
sender and delete the email..
------------------------------------------------------------------