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. Regards, Josh
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.
Hi, 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..