hi all,
I am using oracle 9i. I want to insert long data , so i created one column with clob data type in table. In that i faced tha problem if i insert more than 4000 charater it showing error. kindly say me how to solve it .And the default size of CLOB is 4000 charcter?.it showing 4000 as default during creation of table. can we declare the clob size manually while creating a table .