No Subject

From: Glenn Travis <c-glenn.travis_at_wcom.com>
Date: Tue, 29 May 2001 15:40:09 -0700
Message-ID: <F001.00312D1D.20010529154025@fatcity.com>

I am migrating data from one database[database1] to another[database2]. I have a
link[dblink] between the two and one of the tables[CLOB_TABLE] have CLOB datatype for one of their attributes[CLOB_BODY].

I need to cursor through this CLOB_TABLE and then insert the cursor variable values into database2's table[CLOB_TABLE2].

I get the ORA-22992 error (cannot use LOB locators selected from remote tables) when I run the script.

I tried the INSERT INTO CLOB_TABLE2 SELECT * FROM CLOB_TABLE_at_dblink; on database1
directly but I still get the ORA-22992 error.

Does anyone have a method or code workaround of how to accomplish this?

thanks!

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Glenn Travis
INET: c-glenn.travis_at_wcom.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue May 29 2001 - 17:40:09 CDT