Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: XML Storage in Database

Re: XML Storage in Database

From: Hans Forbrich <forbrich_at_telusplanet.net>
Date: Fri, 16 Nov 2001 08:07:09 GMT
Message-ID: <3BF4CB0E.1C16FC3E@telusplanet.net>


Totally concur - don't use LONG

If you are not restricted to 8.1.7, check out 9i - comes with considerable built-in XML support. (See http://technet.oracle.com for a lot of detail)

"Howard J. Rogers" wrote:

> Don;t touch LONGs witha barge pole... they are strictly out of fashion in
> anything higher than 7, and by 9i, lots of juicy new features simply won't
> work with them. Since XML is not (last time I checked) binary data, that
> leaves CLOBs. Up to 4Gb in size -should just about do the trick!!
>
> Regards
> HJR
> --
>
> Oracle Resources : http://www.hjrdba.com
> =============================
>
> "Mynews" <fogun_at_blueyonder.co.uk> wrote in message
> news:_tqG7.5491$mh1.617448_at_news1.cableinet.net...
> > Hi ,
> >
> > I would like some advice on how/ what is the most suitable data type to
> XML
> > in Oracle 8.1.7. (CLOB, BLOB, LONG)
> >
> > The data stored will be approx 4k which is bigger than Varchar2
> >
> > Regards
> >
> >
Received on Fri Nov 16 2001 - 02:07:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US