FreeLists / oracle-l / Re: update a LONG column HOWTO

[Thomas Day <tomday2@xxxxxxxxx>]

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@xxxxxxxxx> 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@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