DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2002
    Bangalore, India

    ORA-01704: string literal too long

    I am working on VB and Oracle.I had a form which passes a LONG parameter to a Backend Procedure to insert a Data into Table whose datatype is LONG.
    Now my problem is when I tried to insert from the Procedure it does not save and at the backend its give me an error string literal too long . The exact error msg is...

    ORA-01704: string literal too long

    I don't understand Why Oracle is throwing an error when the size of the total data is 7kb and capacity of long datatype in oracle is 2GB.
    Pleases do help me (infact my friend : ).

  2. #2
    Join Date
    Aug 2001
    Waterloo, On
    You can use string literals only upto 4000 characters.
    If your value is longer, you may use bind variables instead.

    Raminder Singh

    Oracle Certified DBA: Oracle 8i, 9i

    Mail me at raminderahluwalia@rediffmail.com.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.