Hi Gurus,

We are trying to store texts (may include XML) in a NCLOB field.


However while retrieving we get ORA-24806: LOB form mismatch
(Does not happen when we use CLOB's)

Appreciate any help.


update parameter set test='1' where parameterpk =1;

select * from parameter where parameterpk =1;


CREATE TABLE PARAMETER
(
PARAMETERPK NUMBER(20) NOT NULL,
NAME NVARCHAR2(50),
DISPLAYTYPE NVARCHAR2(255),
VALUETYPEPK NUMBER(20) NOT NULL,
CURRENTVALUE CLOB,
TEST NCLOB
);


Regards,

Subhash

Oracle LazyDBA home page