-
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
-
You can use string literals only upto 4000 characters.
If your value is longer, you may use bind variables instead.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|