varchar to long convertion
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 .
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
Use PL/SQL. It has a limit of 32000 characters (I think). More than this, you might have to use the OCI calls.
Also try dbms_lob package
Click Here to Expand Forum to Full Width