I created a trigger on a table that contains a CLOB. The trigger creates a before and after image of the CLOB in another table, using the new and old values available to the trigger. When I execute an update statement using a SQL statement, the trigger fires correctly. But, when I update a row using the data grid in Toad, the trigger does not capture the after image of the data.
WORKAROUND:
Use SQL Statement to update CLOB.
STATUS:
Waiting for fix to be released in a future version of Toad for Oracle.
