File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Oracle/OAS and the fly likes Oracle 10g Clob Datatype Cannot Insert data Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Oracle 10g Clob Datatype Cannot Insert data" Watch "Oracle 10g Clob Datatype Cannot Insert data" New topic
Author

Oracle 10g Clob Datatype Cannot Insert data

Arjun Reddy
Ranch Hand

Joined: Nov 10, 2007
Posts: 627
Hi All,

I just created a table with one of the columns being of CLOB datatype and now when I try to insert values into the table, it's showing me that that particular column is not available to insert data? What should I do to resolve this? My create table statement is as follows:



Thanks.

Be Humble... Be Nice.
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30146
    
150

What insert statement are you using?


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Arjun Reddy
Ranch Hand

Joined: Nov 10, 2007
Posts: 627
Jeanne Boyarsky wrote:What insert statement are you using?


I am using the GUI which comes with Oracle 10g and there's no text box for me to insert data for it. For the rest of them, There are text boxes to insert.

Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30146
    
150

Right. YOu can't insert large data types (BLOB and CLOB) through that GUI. In a SQL statement, you can use a function to convert a string to a CLOB for insertion.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Oracle 10g Clob Datatype Cannot Insert data
 
Similar Threads
How to read/write text file to db2 by using java code
Convert large string to Clob
Converting a String to Clob for insert into DB
Problem in writing file to db2 database
insert CLOB into MS SQL Server 2K