Re: CLOB : Inserting or Updating ?

Why "have to write a empty clob first" ? I have inserted only pk value and NULL to the CLOB column

Then later do this is subsequent application:

DECLARE
     l_clob CLOB := some_function_returning_clob ; BEGIN
    UPDATE mytable SET f2= l_clob WHERE f1= 1 ;     COMMIT;
END; Is this right ?
thanks

"Bruintje Beer"
>
> When you insert a row you have to write a empty clob first to the lob
> locator and later update your clob column with the actual clob data.
>
> create table mytable(f1 int primary key, f2 clob);
> insert into mytable(f1, f2) values(1, empty_clob());
Received on Wed Mar 07 2007 - 09:55:36 CST