which datatype should i use to store more than 4000 chars in a column
767604Jan 28 2011 — edited Jan 28 2011Hello friends,
I am currently using following oracle version for my database :
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0
PL/SQL Release 11.1.0.6.0
SQL> create table clobexample( t1 clob );
SQL> insert into clobexample values ('aaaaaaaaaaaaaaaaaaaa.....');
Error at Command Line:2 Column:8
Error report:
SQL Error: ORA-01704: string literal too long
01704. 00000 - "string literal too long"
*Cause: The string literal is longer than 4000 characters.
*Action: Use a string literal of at most 4000 characters.
Longer values may only be entered using bind variables.
My query is that which datatype should i use in the table to enter more than 4000 characters in the table, I even tried it with clob (Above example) but it did not support .
Is there any other way for making it possible?
Please help me out.
Thank you in advance.
Regards.