update a LONG column HOWTO

From: sarath kumar <sarath_kumar0@xxxxxxxxx>
To: oracleMail List <oracle-l@xxxxxxxxxxxxx>
Date: Thu, 30 Jun 2005 18:19:47 -0700 (PDT)

I have LONG column in 9.2.0.3 database, i am updating
as follows thru database link, i Could update them if
the column size is small, The column might be some kb
not MB, how to specify the size of LONG Column
SQL> set LONG 320000
SQL> l
  1  declare
  2  l_str LONG;
  3  begin
  4  select content into l_str from tos@devvdv where
tos_id = 2012;
  5* end;
SQL> /
declare
*
ERROR at line 1:
ORA-01406: fetched column value was truncated

ANY SUGGESTIONS
-sarath

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
--
http://www.freelists.org/webpage/oracle-l

update a LONG column HOWTO

Other related posts: