Re: Error: ORA-01704: string literal too long
Date: Fri, 14 Nov 2003 15:10:43 -0500
Message-ID: <NaqdnYzsEfdQqyiiRVn-uA_at_comcast.com>
according to the error message manual:
ORA-01704 string literal too long
make sure you get yourself a copy for future reference ;-)
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.
"Dave Pylatuk" <davep_at_centurysystems.net> wrote in message
news:U9atb.45866$xI2.1106301_at_news20.bellglobal.com...
| Hello, I am getting the above error when executing a large insert
statement
| against 8.1.7.
|
| This insert statement includes a very large string value, about 8000
| characters long. Is there a limit on the size of statements that Oracle
| can execute ?
|
| Is this a setting that can be changed ?
|
| Thanks in advance.
|
|
|
Received on Fri Nov 14 2003 - 21:10:43 CET