[Logo]
Forums Register Login
Oracle 10g Clob Datatype Cannot Insert data
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.
What insert statement are you using?
 
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.

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.
Wink, wink, nudge, nudge, say no more ... https://richsoil.com/cards



All times above are in ranch (not your local) time.
The current ranch time is
Nov 24, 2017 19:19:51.