Vijay

• Jul 9th, 2005

 

Yes it possible to insert/update/delete data for CLOB, BLOB, NCLOB columns. Now how to do it. 
 
1. Suppose if you are using JAVA applications to modify the database columns, then you have to open streaming connections to write data for these columns where the streaming connections can be ASCII as well as Binary connections. See the java docs for that. 
2. From SQL plus it not possible to write as max value that can be written is 4000 chars. 
3. From PL/SQL you have to use the dbms_lob.writeappend packages for inserting data. 
 
The User Defined TYPE can contain these datatypes CLOB,BLOB,NCLOB be part of user defined records or datatype by record i mean  
type rec_blob is record( l_str clob);