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