Toad World® Forums

SQL Nav 7.1 and 6.7. :new value from a clob field in a trigger shows the :old value in the SQL Editor

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

Hi Martin,

Thanks for your feedback, we have create story SQLNAV-1779 for it and will fix later.

Thanks,

Alan