Forum OpenACS Q&A: Oracle CLOB changes not seen by Trigger

Collapse
1: Oracle CLOB changes not seen by Trigger
Posted by Ryan Gallimore on 10/03/13 04:22 PM
There is a shortcoming in OCI [1] (used by nsoracle) when saving clobs with db_dml -clobs. Triggers do not see clob updates so the :NEW.clob value in any triggers is always null.

Has anyone found a workaround for this?

[1] http://docs.oracle.com/cd/B19306_01/appdev.102/b14289/dcilobs.htm#i1005107