Hi, ...


I'm Trying to create an UPDATE statement using the DECODE function in Oracle8 on a LOB field.

Yes, I know it will throw an error about inconsistent datatype.

my question is, is there any workaround for this thing ?
(I don't want to write my own PL/SQL function that will try to do what i want, if there is a simplier way ... ).


my statement is :

UPDATE test_table SET lob_type = DECODE(1, 1, 'TEST', lob_type);