how to insert very large text into CLOB datafield?urgent.....

[shivapadma]

I want explanation for CLOB datafield

1.I created clobtable with the query
create table clobexample(id number,text CLOB);

2.I tried to insert very large text by the following query

insert into clobexample(1,' here i added very large text');

3.the error is
SP2-0232: Input too long. Must be less than 241 characters

why i am unable to insert very large text in CLOB field.

[amitpatel66]

[code=oracle]
SQL> create table clobexample(id number,text CLOB);

Table created.

SQL> insert into clobexample values(1,'here i added very large text')
SQL> /

1 row created.

SQL> select * from clobexample;

ID
----------
TEXT
--------------------------------------------------------------------------------
1
here i added very large text


SQL>
[/code]

Your insert statement is of incorrect syntax!!

[debasisdas]

use this

[code=oracle]create table clobexample(id number,text CLOB);

insert into clobexample values(1,'here i added very large text');
[/code]

[shivapadma]

use this

[code=oracle]create table clobexample(id number,text CLOB);

insert into clobexample values(1,'here i added very large text');
[/code]

if i give below 241 characters insert query is accepting .But,if more than 241 charcters are inserted i am getting error

SP2-0232: Input too long. Must be less than 241 characters

[debasisdas]

I have executed this successfully without any errors.
[code=oracle]
INSERT INTO clobexample VALUES(1,'here i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large text');
[/code]

What is the version oracle that you are using ?

[shivapadma]

I have executed this successfully without any errors.
[code=oracle]
INSERT INTO clobexample VALUES(1,'here i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large texthere i added very large text');
[/code]

What is the version oracle that you are using ?

the version i am using is oracle10g.

[debasisdas]

the version i am using is oracle10g.

I have also executed on 10.2.0.1.0 and it is working fine for me without any error.

[BMantri]

Hello,

U have skipped the VALUES clause in the insert statement.

The correct sysntax is

insert into table_name(col1 , col2) values ( val1, val2);


Thanks,
BMantri