Hi
Some simple code to test this matter :
DROP TABLE clobtab;
CREATE TABLE clobtab(id NUMBER, c CLOB);
CREATE OR REPLACE TRIGGER clobtab_trigger
AFTER UPDATE
ON clobtab
REFERENCING NEW AS new OLD AS old
FOR EACH ROW
BEGIN
DBMS_OUTPUT.put_line(‘old value=’ || :old.c);
DBMS_OUTPUT.put_line(‘new value=’ || :new.c);
END;
INSERT INTO clobtab
VALUES (1, ‘old’);
COMMIT;
UPDATE clobtab
SET c = ‘new’
WHERE id = 1;
COMMIT;
I get :
old value=old
new value=new
Perfect.
Now I change the clob field value in the SQL editor from SQL Navigator from ‘new’ to ‘very new’ + commit and I get :
old value=new
new value=new
Second try : I change the clob field value in the SQL editor from SQL Navigator from ‘very new’ to ‘incredible’ + commit and I get :
old value=very new
new value=very new
Regards
Martin