Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Oracle 10g Clob Datatype Cannot Insert data

 
Arjun Reddy
Ranch Hand
Posts: 629
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34973
379
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What insert statement are you using?
 
Arjun Reddy
Ranch Hand
Posts: 629
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 34973
379
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic