Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Two LONG RAW fields in one table?
Yes, according to the Oracle rul book you can have only 1 long/long raw per table in Oracle7, in Oracle8 you convert to LOBs and have multiples.
Matthew Arrocha
marrocha_at_bellsouth.net
Michael Jenc <jenc_at_cas_software.de> wrote in article
<34477433.6FFF_at_cas_software.de>...
> Hi,
>
> have you ever tried to create a table that contains two
> fields of the LONG RAW datatype?
> I get the error message that this is not possible. For
> me this is very sad. I thought that Oracle would be a good
> choice for huge databases...
>
> OK, a solution would be to split that table into two and
> define a view that selects both. But in my application
> I would have to write lots of extra code to edit and to
> insert records into such a view.
>
> Are there any other soltions than the above?
>
> Bye and thanks in advance
> Michael
> --
> *********************************************************
> Michael Jenc
> CAS Software GmbH
> Karlsruhe, Germany
>
> Replace the '_' with '-' in E-mail address to contact me
>
Received on Tue Oct 28 1997 - 00:00:00 CST