1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice


Discussion in 'Oracle' started by josh, Mar 2, 2007.

  1. josh

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

  2. shabbir

    shabbir Administrator Staff Member

    Moved to Orcale forums from Introduce yourself.
  3. pradeep

    pradeep 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.
  4. josh

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

Share This Page