Home » SQL & PL/SQL » SQL & PL/SQL » Convertion long to clob
Convertion long to clob [message #424521] Fri, 02 October 2009 23:27 Go to next message
ajitpal.s
Messages: 204
Registered: November 2006
Senior Member
Hi,

Is there any way to convert long to clob remotely and insert in a table, i tried the following but was given an error

insert into t_test 
(select to_lob(comments) from organazation@test)


Error Message:
ORA-00997: illegal use of LONG datatype
Re: Convertion long to clob [message #424523 is a reply to message #424521] Sat, 03 October 2009 00:17 Go to previous messageGo to next message
ajitpal.s
Messages: 204
Registered: November 2006
Senior Member
Just in addition to the post above, i cant make use of the copy command as i have not got login credentials of the remote database.

Any workaround would be great appreciated
Re: Convertion long to clob [message #424544 is a reply to message #424523] Sat, 03 October 2009 05:37 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
That would probably depend on the database version, which might be quite old, since LONGS were decrapated about 10 years ago. It also depends on how long the actual stored LONGS are.

The short answer is, it might be impossible to do on the server, you will need a client program do to it (Like with the SQL*Plus copy command).

There is a discussion about the problem on Ask Tom.
Re: Convertion long to clob [message #424545 is a reply to message #424544] Sat, 03 October 2009 05:42 Go to previous message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
ThomasG wrote on Sat, 03 October 2009 11:37
LONGS were decrapated about 10 years ago

Freudian Slip? Wink
Previous Topic: count rows in tables
Next Topic: trigger needed
Goto Forum:
  


Current Time: Sat Dec 03 14:10:31 CST 2016

Total time taken to generate the page: 0.10769 seconds