varchar to long convertion

[prakashs43]

Hi friends ,

we have a column with width varchar2(4000) ,

we want to increase width to 6000 characters ....

if we migrate to LONG DATATYPE
how to use insert and select more than 4000 characters in sqlplus .

this column is extensively used in application ...

Thanks for your feedback .

[DaPi]

You should consider using CLOB instead of LONG.

http://download-west.oracle.com/docs...a96591/toc.htm

http://www.orafaq.com/papers/lobs.doc

[prakashs43]

Hi

I tested in 8.1.6 a,d 8.1.7 databases creating
LONG COLUMN AND CLOB .

using insert statement we can insert upto 4000 characters .
if we try to insert more than 4000 characters . it throws following error message

ORA-01704: string literal too long.
in both the cases ..

is there any workaround for this ... so that we don't need to change entire application and we can use direct insert statement to insert more than 4000 characters .

our application uses insert statement directly ...

thanks for any kind of suggestions

[Raminder]

Use PL/SQL. It has a limit of 32000 characters (I think). More than this, you might have to use the OCI calls.

[Raminder]

Also try dbms_lob package
dbms_lob.load_from_file ??