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 Thu Nov 08 2001 - 01:55:49 CST
