A B (JIRA) wrote: > Update triggers on tables with blob columns fail at execution time if the > triggered-SQL-statement references the blob column(s).
I'm suprised this is not documented, BLOB and CLOB columns do not work with triggers. This is because within the database engine, there is no mechanism to create a java.sql.Blob object (or Clob) from a SQL BLOB (CLOB) datatype. The java.sql.Blob returned from a ResultSet is handled at the JDBC layer, not within the engine. This is the same reason as to why BLOB and CLOB types cannot be passed into a method or function. Dan.
