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_at_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
Received on Thu Jun 30 2005 - 21:25:13 CDT
