Re: convert db2 varchar2(8000) to oracle blob

From: Chet Justice <chet.justice_at_pfsf.org>
Date: 26 Apr 2005 11:40:12 -0700
Message-ID: <1114540812.957388.94620@g14g2000cwa.googlegroups.com>

>iirc, you can *update* across a dblink...
>So create as select CAS_SQ_R, CAS_CHRON_SQ_R, null,
>followed by an update.
>I know - two way pass where a single should do, but...
>no varchar2(8000) in oracle.
>--
>Regards,
>Frank van Bortel

Hadn't thought of that, but it did not work.

LOADER_at_TESTING>UPDATE t SET x = (SELECT chron_x FROM reppd.pfs_cas_chron_note_at_hsn WHERE cas_chron_sq_r = 6478152000); UPDATE t SET x = (SELECT chron_x FROM reppd.pfs_cas_chron_note_at_hsn WHERE cas_chron_sq_r = 6478152000)

                         *

ERROR at line 1:
ORA-00997: illegal use of LONG datatype

Elapsed: 00:00:00.01
LOADER_at_TESTING>UPDATE t SET x = (SELECT TO_LOB(chron_x) FROM reppd.pfs_cas_chron_note_at_hsn WHERE cas_chron_sq_r = 6478152000); UPDATE t SET x = (SELECT TO_LOB(chron_x) FROM reppd.pfs_cas_chron_note_at_hsn WHERE cas_chron_sq_r = 6478152000)

                                                    *

ERROR at line 1:
ORA-00997: illegal use of LONG datatype Received on Tue Apr 26 2005 - 13:40:12 CDT