Loading

ORA-01704: string literal too long...?

Sompal Arya

12y2.8kOracle

i m trying to save a string containing more than 4000 characters in oracle .i got an error .

It is because CLOG Data Type in oracle can store more maximum 4000 characters.Please Suggest me Solution .

I have try some methods to achieve this task.But they are not working on Sever.

Thanks in advance

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Wim Sturkenboom12y ago
Not an Oracle man, but there are a few suggestions on the web ;) Just search for ORA-01704 ;)
As you don't say what you've tried, have a look at them and ignore the solutions that you've tried.

Knowing nothing about Oracle, this sounds like making sense: https://community.oracle.com/thread/1068414