Re: update a LONG column HOWTO

Use the sqlplus "copy" command.

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a90842/apb.htm#634269

COPY {FROM database | TO database | FROM database TO database} {APPEND|CREATE|INSERT|REPLACE} destination_table [(column, column, column, ...)]
USING query

where database has the following syntax:

username[/password]@connect_identifier

Copies data from a query to a table in a local or remote database. COPY supports the following datatypes:

CHAR
DATE
LONG
NUMBER
VARCHAR2 On 6/30/05, sarath kumar <sarath_kumar0_at_yahoo.com> wrote:
> 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
>

--
http://www.freelists.org/webpage/oracle-l