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

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
Received on Tue Feb 04 2003 - 17:17:50 CST