josh's Avatar, Join Date: Mar 2007
Newbie Member
Hi Guys,

Im getting an error "ORA-01704 string literal too long" when I tried to update a column of varchar2.The value which iam giving is less than the width of column but still i get this error.Iam doing this updation through front end(i.e. APPLIX).
Plz any body can help me.

shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
Moved to Orcale forums from Introduce yourself.
pradeep's Avatar, Join Date: Apr 2005
Team Leader
according to the error message manual:

ORA-01704 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.
josh's Avatar, Join Date: Mar 2007
Newbie Member

I think you have not understood my problem.Let me once again explain it.

Iam updating one of the fields(name of customer) which is of varchar2(30) datatype.Iam doing this updation through GUI.Other fields are also their on the GUI for which data is already existing.Iam not touching those fields.
But Iam simply updating the name field to some other name which is of 10 characters long.But still Iam getting this errror.

I know if the string length is more than the width of the column,then we will get that error ORA-01704 string literal too long.

Plz help..