Re: Regarding CLOB data type

CLOB is new feature of Oracle8 server.

SQL> insert into <tablename>

   2> values (empty_clob());
SQL> declare

         temp varchar2(100);
         tmp_clob clob;
         begin
             temp := 'Hi there';
             select clobcolumn into tmp_clob from <tablename> where id = 1
             for update;
             dbms_lob.write(tmp_clob, length(temp),1, temp);
             commit;
         end;
         /

You must use empty_clob() when insert and change its value in PL/SQL block. DBMS_LOB package used for manipulating LOBs and must use 'select ... for update' clause for locking rows.

"KISHORE" <kishore.chekuri_at_geind.ge.com> wrote in message news:sv2hfskhigkfc5_at_corp.supernews.com...
> Hai ,
> I have a table with one of it's fields as CLOB type.
>
> Can some one tell me in detail How to insert , update rows into this
 table?
> Reply me as soon as possible?
>
>
> --
> Posted via CNET Help.com
> http://www.help.com/
Received on Sat Oct 21 2000 - 09:22:04 CDT