Home » SQL & PL/SQL » SQL & PL/SQL » Insertion of long column into clob column
Insertion of long column into clob column [message #214827] Thu, 18 January 2007 04:14 Go to next message
vikram1780
Messages: 222
Registered: January 2007
Location: Bangalore
Senior Member
Hi Anyone help in resolving this problem

How can we insert long columns into clob datatype column.

Its saying as ora 01704: string literal too long

Thanks in advance
Re: Insertion of long column into clob column [message #214837 is a reply to message #214827] Thu, 18 January 2007 04:31 Go to previous messageGo to next message
dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai
Senior Member
hi,

 doesn't to_lob() help you in resolving the issue.



regards,
Re: Insertion of long column into clob column [message #214847 is a reply to message #214827] Thu, 18 January 2007 04:39 Go to previous message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Have you consider modifying your long column to a clob column instead ?

alter table test modify longcol CLOB


works from 9i and up
Previous Topic: EXISTS in the IF statement
Next Topic: Import/Export data from/to text file
Goto Forum:
  


Current Time: Sat Dec 10 11:15:50 CST 2016

Total time taken to generate the page: 0.13726 seconds