Re: Oracle data type

From: Uthuras <uthuras_at_hotmail.com>
Date: 5 May 2004 23:02:46 -0700
Message-ID: <2ebe688f.0405052202.1ca42966@posting.google.com>

Thanks for all the input guys!

uthuras

Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl> wrote in message news:<v9tg90d2c0usjruu03hs6h8500ee6r1q8o_at_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
Received on Thu May 06 2004 - 01:02:46 CDT