aspose 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: 629
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
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 30947
    
158

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: 629
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
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 30947
    
158

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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Oracle 10g Clob Datatype Cannot Insert data