|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
August 3rd, 2005, 02:52 PM
|
|||
|
|||
|
String Literal Too Long error
I am having a bit of an issue. When inserting data larger than 4000 characters into a CLOB I am getting the String Literal Too Long error. I have initialized the CLOB and am able to insert things smaller than 4000 characters but nothing larger. Any help would be greatly appreciated.
__________________
http://www.dieselstudios.com - http://www.trackmycash.com - http://www.hamptonsoftrentdale.com
|
|
#2
August 3rd, 2005, 04:27 PM
|
||||
|
||||
|
That's because you are using a straight insert statement, see here
__________________
My blog about OpenSource Databases PDF tutorials about OSS databases, DBMonster ... Please contribute to Open Source Development, fill bug reports!!! Developer Shed eSupport Commented my.ini/my.cnf (PLEASE ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins
|
|
#3
August 4th, 2005, 07:43 AM
|
|||
|
|||
|
What is this example in? I would need an example in Oracle since I am working directly with it.
Quote:
|
|
#5
August 4th, 2005, 11:17 AM
|
|||
|
|||
|
You have to update the CLOB incrementally, in 32K chunks using the stored procedure DBMS_LOB.
Here is a complete example with a good PL/SQL (you have to use PL/SQL ) example: http://www.orafaq.com/forum/t/48485/2/ Last edited by pabloj : August 4th, 2005 at 01:08 PM. Reason: Url tags added
|
|
| Viewing: Dev Shed Forums > Databases > Oracle Development > String Literal Too Long error |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
