Oracle 10g Clob Datatype Cannot Insert data

[Arjun Reddy]

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:

Create someTable
(
File varchar2(255),
Text CLOB
)

Thanks.

[Jeanne Boyarsky]

What insert statement are you using?

[Arjun Reddy]

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]

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.