Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

use of CLOB

 
dr priti
Greenhorn
Posts: 18
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
arunkumar hk
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
martin samm
Ranch Hand
Posts: 31
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic