update a LONG column HOWTO 2005-07-01 - By Thomas Day
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]@(protected)
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@(protected)> 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@(protected) where
> tos_id = 2012;
> 5* end;
> SQL> /
> declare
> *
> ERROR at line 1:
> ORA-01406 (See ORA-01406.ora-code.com): 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
|
|
