I am receiving data which is too big for one of the database fields. I created a trigger to truncate the data to the correct size:
However, when the field is too big, the error seems to appear before the trigger is invoked. If the field is the correct length, the trigger is clearly executed.
Is this the expected behavior? Am I doing something wrong?
Oracle Database 11g Enterprise Edition Release 18.104.22.168.0 - 64bit Production
PL/SQL Release 22.214.171.124.0 - Production
CORE 126.96.36.199.0 Production
TNS for 64-bit Windows: Version 188.8.131.52.0 - Production
NLSRTL Version 184.108.40.206.0 - Production