Re: Does this look like a bug to you guys?
From: Steve Baldwin <stbaldwin_at_multiservice.com>
Date: Wed, 16 Mar 2016 13:50:19 +1100
Message-ID: <CAC-6Hs3VJx1H0wRe7pz7YQjpHj_2QfKQ9o4zyk5dFLzcGPOrEw_at_mail.gmail.com>
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?".
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..
Date: Wed, 16 Mar 2016 13:50:19 +1100
Message-ID: <CAC-6Hs3VJx1H0wRe7pz7YQjpHj_2QfKQ9o4zyk5dFLzcGPOrEw_at_mail.gmail.com>
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..
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Mar 16 2016 - 03:50:19 CET