Re: Oracle data type

From: Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl>
Date: Wed, 05 May 2004 07:03:14 +0200
Message-ID: <v9tg90d2c0usjruu03hs6h8500ee6r1q8o@4ax.com>

On 4 May 2004 21:13:09 -0700, uthuras_at_hotmail.com (Uthuras) wrote:

>Greetings,
>
>Is there any known case of oracle allowing only one column of LONG
>data type in a table? The orcale 8 and 9 does not allow us to create
>more than one LONG data type in a particular table.
>
>Why is it so ? Is there any limitation to it ?
>
>Please advice.
>
>Thanks
>
>Uthuras

This is a known and more importantly *documented* restriction (which has existed since Oracle 6) and this is why LONGs are *deprecated*. Please
- use CLOBs instead
- consult the documentation prior to asking doc questions

--
Sybrand Bakker, Senior Oracle DBA

Received on Wed May 05 2004 - 00:03:14 CDT