Re: Stored Procedure: Transfering data from one table to another from one db to another

From: Frank <fvanbortel_at_netscape.net>
Date: Wed, 05 Feb 2003 21:41:35 +0100
Message-ID: <3E4176FF.30304@netscape.net>

RKNR3755 wrote:

> I tried using the dbms_lob.  But unfortunately, it did not work.  
> 
> Frank, can you explain this a bit more. When I tried like what you
> suggested, it is not recognizing the localCLOBcol.  Can you elaborate.
>  Thanks a bunch.
> 
> 

>>>To reply remove -verwijderdit from my e-mail address
>>
>>Does that work over db links? I have had soem trouble with
>>CLOBs over db links (or, more accurate, the pointers).
>>Update x_at_remote set x.CLOBcol = localCLOBcol did the trick.
>>Unfortunately, You need a temporary table (which - depending
>>on the application, could be a global temporary table).
>>
>>Frank

>

Answered via private mail Received on Wed Feb 05 2003 - 14:41:35 CST