Thanks for all the input guys!

uthuras


Sybrand Bakker <gooiditweg@sybrandb.verwijderdit.demon.nl> wrote in message news:<v9tg90d2c0usjruu03hs6h8500ee6r1q8o@4ax.com>. ..
> On 4 May 2004 21:13:09 -0700, uthuras@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