DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: ORA-01704: string literal too long

  1. #1
    Join Date
    Aug 2002
    Location
    Bangalore, India
    Posts
    405

    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 : ).
    -nagarjuna

  2. #2
    Join Date
    Aug 2001
    Location
    Waterloo, On
    Posts
    547
    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