Re: How to copy LONG column

From: Zmoxie <zmoxie_at_aol.com>
Date: 1997/05/21
Message-ID: <19970521203901.QAA09001@ladder02.news.aol.com>#1/1

Dealing with long and long raw is the painful job in Oracle. 1. no way to move Long Raw within Oracle. to move Long Raw, you have

   to writ C code using OCI's picewise functoin. 2. for long, you can only move it using plsql code.

1. if the data is <32K, using plsql code to move it.
2. if the data is >32K. out of luck. go OCI solution.
3. there is function in rdbms_sql that can do picewise retrive for long. but none for insert.
4. Oracle 8 solove all the problem by new data type LOB and set of build-in package to handle it.

Moxie

---

Moxie J. Zhang @ Deloitte & Touche Consulting Group, DRT System

zmoxie_at_dttus.com
Moxie.J.Zhang_at_worldnet.att.com, zmoxie_at_aol.com

---

Received on Wed May 21 1997 - 00:00:00 CDT