Hi folks, I want to take text from text area and insert it into CLOB datatype of Oracle8i database. But I could insert upto 4000 chars. What could be the problem. As per my knowledge CLOB datatype size is 4GB. Thanx in advance for any replies. Priti.
A direct insert into the CLOB field does not work if the data exceeds 4000 characters. Use the DBMS_LOB pacakage to access and manipulate the (C)LOB data. The feature of loading data directly from varchar2 to a CLOB field using an INSERT statement is not available in 8.0.x and 8.1.5. This feature is available in 8.1.6 and later versions. rgds arun.
another way to put information into a CLOB is to select the clob field you wish to populate, and then open up a stream to it and then 'send' the information to it. This is well documented on Oracle's TECHNET site (technet.oracle.com) - look in the Documentation, Oracle 8i, Java Development section