473,327 Members | 1,976 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

Error: ORA-01704: string literal too long

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.

Jul 19 '05 #1
3 38826
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.

make sure you get yourself a copy for future reference ;-)

-- mcs

"Dave Pylatuk" <da***@centurysystems.net> wrote in message
news:U9*********************@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.
|
|
|
Jul 19 '05 #2
Thanks for responding.

Do you have an example of using a bind variable ?

Any help would be appreciated.
Thanks,
Dave
"mcstock" <mc*************@spamdamenquery.com> wrote in message
news:Na********************@comcast.com...
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.

make sure you get yourself a copy for future reference ;-)

-- mcs

"Dave Pylatuk" <da***@centurysystems.net> wrote in message
news:U9*********************@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.
|
|
|

Jul 19 '05 #3
Dave Pylatuk wrote:
Thanks for responding.

Do you have an example of using a bind variable ?

Any help would be appreciated.
Thanks,
Dave
"mcstock" <mc*************@spamdamenquery.com> wrote in message
news:Na********************@comcast.com...
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.

make sure you get yourself a copy for future reference ;-)

-- mcs

"Dave Pylatuk" <da***@centurysystems.net> wrote in message
news:U9*********************@news20.bellglobal.c om...
| 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.
|
|
|


insert into bla (a, b, c) values (:x, :y, :z);
:x, :y and :z are the bind variables.

Yuou would use it in a statement like:

begin
for i in 1..100 -- or a select statement
execute immediate
'insert into bla (a, b, c) values (:x, :y, :z)'
using a_variable, another_variable, yet_another;
end loop;
end;

--
Regards, Frank van Bortel

Jul 19 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Park Yeon Jo | last post by:
About Error : ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor I installed Oracle 8.1.7 on Windows XP Professional. and I wanto connect to that server...
1
by: valexena | last post by:
I am attempting to take tablespace offline and receiving the following error: ORA-01546- cannot take tablespace offline. What I am doing wrong? -- Posted via http://dbforums.com
0
by: Brian Lesker | Impulse Info Systems | last post by:
Keywords: Oracle 6i Citrix ORA-06508 Crash Problem descryption: Oracle (6i) application crashes in Citrix farm with error ORA-06508. HOWTO resolve:
2
by: pooja sharma | last post by:
When I have installed oracle 8i on my window xp it was working alright. but when i rebooted the system and to logged in SQL+ it is giving error ORA-01034: ORACLE not available . Can anybody tell me...
1
by: 3xxx | last post by:
I start to learn the form now with oracle 9i environment (this URL appear after running menu in Oracle forms builder ==>>> program-> run form) ...
3
by: Thakur vikas | last post by:
when we run the query then we got ": (Error): ORA-00907: missing right parenthesis" what may be the error?
2
by: sushil4487 | last post by:
I am getting this error while writing this query. I am using the same query in other server but i am not getting any error message Do I need to reset the date format in Server. Date is saved in...
2
by: amoldiego | last post by:
Hi I have encountered the error ORA-01536 . I have earlier grant sysdba to SCOTT & then I revoked the sysdba role from SCOTT a couple of days later. After that, I encountered the error...
1
by: gowthams123 | last post by:
Dear All, Plz help me with this oracle form builder installation? I have installed SQL *PLUS Release 9.2.0.1.0 and then installed form builder 9.0.2.7.0. When i enter the following username...
0
by: Muhammad Asad | last post by:
While attempting to login in SqlPlus at start i found such error.When i entered again user name and passowrd it again show that message. Error. ORA 12535: TNS operation time out. How can i resolve...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.