How to copy a CLOB from one table to another using pl/sql

From: Dev <d_pal1_at_hotmail.com>
Date: 24 Aug 2001 10:57:38 -0700
Message-ID: <e81d6448.0108240957.7f0faec7_at_posting.google.com>

The situation is, I have a table in which I have an id column and a column with datatype CLOB and I want to copy some of these clobs to another table with a clob datatype column. Can somebody specify how to copy a clob from one table to another using PL/Sql
I tried using dbms_lob.copy but somehow that doesnt seem to be working.
TIA Received on Fri Aug 24 2001 - 19:57:38 CEST

This message: [ Message body ]
Next message: Scott Mattes: "copying data from one computer to another, without export"
Previous message: thierry Chauville: "ORA-02020 TOO MANY DATABASE LINK IN USE"
Next in thread: Ted Chyn: "Re: How to copy a CLOB from one table to another using pl/sql"
Reply: Ted Chyn: "Re: How to copy a CLOB from one table to another using pl/sql"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message