Home » SQL & PL/SQL » SQL & PL/SQL » Unable to insert the data..pls
Unable to insert the data..pls [message #185951] Fri, 04 August 2006 08:22 Go to next message
sreehari
Messages: 101
Registered: May 2006
Senior Member
Hi all

i have data of 25000 characters in XML format..when i try to insert this data in CLOB column, i am getting the error like

ORA-01704:string literal too long

Why it is so..how can i insert the data into the column..

Pls help..

Thanks
Re: Unable to insert the data..pls [message #185954 is a reply to message #185951] Fri, 04 August 2006 08:48 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
I suspect that you will get this error from SQL. In SQL, a varchar2 string has a limit of 4000 chrs. TO get a 25000 chr string, you'd need to use pl/Sql
Re: Unable to insert the data..pls [message #186012 is a reply to message #185951] Fri, 04 August 2006 14:12 Go to previous message
Bill B
Messages: 1484
Registered: December 2004
Senior Member
Check out the following link.

http://download-east.oracle.com/docs/cd/B10501_01/appdev.920/a96612/d_lob2.htm#1013013
Previous Topic: Using Database Links
Next Topic: Import coma seperated text file in to a table ORACLE 10g
Goto Forum:
  


Current Time: Tue Dec 06 00:01:37 CST 2016

Total time taken to generate the page: 0.10792 seconds