Re: Export of Long-Field

From: Sergei Didur <sergei_didur_at_yahoo.com>
Date: 1998/02/10
Message-ID: <01bd3639$b19e0180$79a06080@sdidur-1>#1/1

You could use CURSOR to read data from source table and INSERT to put it into another:

BEGIN
   OPEN source_data FOR SELECT * FROM source_table    count := 0;

   LOOP

      IF count < 1000 THEN
         FETCH source_data INTO source_buffer;
         EXIT WHEN source_data%NOTFOUND;

         INSERT INTO dest_table VALUES(
             ......,
             ......,
             ......,
             source_data.LongField);

         count := count + 1;
      ELSE
         COMMIT WORK;
         count := 0;
      END IF;

   END LOOP;
   CLOSE source_data;
   COMMIT WORK;
END;

-- 
Sergei Didur
Systems Analyst

Olav Dreier <dreier_at_sdm.de> wrote in article <6bmmuh$cq$1_at_bsdti6.sdm.de>...


> I need to export a couple of Long-fields from an Oracle-DB. Since these

> fields use the 32k-limit a VARCHAR2 isn't possible. This needs to be done

> since I have to migrate the data from one data-model to another. The

 manual


> states that it isn't possible to export Long-fields.

> 

> The possibility of using Microsoft Access via ODBC could work but I'd

 rather


> not use it.

> 

> Does anyone have a solution for this problem by using Oracle tools or SQL?

Received on Tue Feb 10 1998 - 00:00:00 CST