1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Ora-01704

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

  1. josh

    josh New Member

    Joined:
    Mar 2, 2007
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    0
    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
     
  2. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,292
    Likes Received:
    365
    Trophy Points:
    83
    Moved to Orcale forums from Introduce yourself.
     
  3. pradeep

    pradeep Team Leader

    Joined:
    Apr 4, 2005
    Messages:
    1,646
    Likes Received:
    86
    Trophy Points:
    0
    Occupation:
    Programmer
    Location:
    Kolkata, India
    Home Page:
    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

    Joined:
    Mar 2, 2007
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    0
    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..
     

Share This Page