Go4Expert (http://www.go4expert.com/)
-   Oracle (http://www.go4expert.com/forums/oracle-forum/)
-   -   Ora-01704 (http://www.go4expert.com/forums/ora-01704-t3230/)

josh 2Mar2007 20:36

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 5Mar2007 09:17

Re: Ora-01704
Moved to Orcale forums from Introduce yourself.

pradeep 5Mar2007 16:11

Re: Ora-01704
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 5Mar2007 21:03

Re: Ora-01704

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..

All times are GMT +5.5. The time now is 07:27.