Re: Oracle 8.0.3 and 'long raw' datatype

From: <markp7832_at_my-deja.com>
Date: Mon, 30 Aug 1999 13:02:23 GMT
Message-ID: <7qdvcp$khe$1@nnrp1.deja.com>

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 Mon Aug 30 1999 - 08:02:23 CDT