Re: Oracle 8.0.3 and 'long raw' datatype

In Oracle8i you also can have only one column LONG per table but you may have several columns CLOB or BLOB).

Martin

markp7832_at_my-deja.com wrote:
>
> In article <7qauet$5no$1_at_trex.antw.online.be>,
> "Hans Demedts" <hdemedts_at_innet.be> wrote:
> > Hey,
> >
> > In Oracle 7 you could only use 1 long raw field per table.
> > I thought this was changed in Oracle 8. I tried to put 2 long row
> fields in
> > 1 table and I still get the message that there is only 1 allowed.
> >
> > Is this possible in Oracle 8.1.5 ?
> >
> > Thanks for your reply.
> >
> > Hans Demedts
> > Belgium.
> >
> The raw and long raw data types are obsolete and exist for backward
> compatibility only starting with version 8+. For new development you
> should be using the LOB data types: BLOB, CLOB, and BFILE along with
> the dbms_lob package. You can have more than one lob column per row so
> this should allow you to do what you want.
>
> There is an entire chapter on LOB's and use of dbms_lob in the
> Application Developers Guide.
>
> Good luck.
> --
> Mark D. Powell -- The only advice that counts is the advice that
> you follow so follow your own advice --
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Sun Sep 05 1999 - 07:59:20 CDT