HELP : Using multiple LONG fields in one table

From: sector Sociale Zaken <wdverba_at_wirehub.nl>
Date: 1997/11/13
Message-ID: <01bcf045$ed8642a0$4389b0c1@pudevserver>#1/1

Hi all,

Is it possible to use multiple LONG fields in one table.

We have (in a DB2 database) a table called TXTFIELDS containing 5 fields of the long datatype; these fields must be able to contain approx. 5000 characters each.

We are going to migrate the DB2/6000 database to a Oracle 7.3.3 database on Windows NT.
On creating the Oracle tables we found out that a table can only contain one Long field.

The only solution we found out was creating 5 tables, each containing one Long field.
The problem then is that we have to adjust the SQL staements for the insert and update procedures.

Is there a workaround for this, so we don't have to modify our SQL statements when inserting or updating rows in the 5 tables.

Any help is appreciated,

Greetings,

Bart H.M. Verwijst

for E-mail reply, please use the address below

---

Bart H.M. Verwijst
Software Development Manager

Sector Sociale Zaken Tilburg - The Netherlands

Phone	+31 (0)13 542 92 61 
Fax	+31 (0)13 542 97 10
Mobile	+31 06 53 87 15 47
E-mail	: superdev_at_pi.net


===============================================

Received on Thu Nov 13 1997 - 00:00:00 CST