Re: xml in oracle 8i and multiple varchar2 fields

From: Justin Cave <jocave_at_yahoo.com>
Date: 18 Sep 2002 08:30:32 -0700
Message-ID: <233b7a65.0209180730.1b166103@posting.google.com>

Well, there's the XMLType data type as well. I'm not sure why you object to storing XML in a CLOB, though, so I'm not sure exactly what you're trying to accomplish/ avoid.

Justin Cave

jriker1_at_yahoo.com (John) wrote in message news:<e6bb5a8d.0209180214.3ea77834_at_posting.google.com>...
> I'm guessing from looking thru the newsgroups, short of going to a
> long or LOB type, I'm not going to be able to break the 4000 character
> limit of a VARCHAR2 in Oracle 8.1.7. I have some XML data that will
> definitely go over that limit. I read some references to using
> multiple varchar2 fields or something, but would have no clue how to
> insert/select from them and know which have multiples and the like. I
> remember an article I read on this, but can't find it now. Any help
> on inserting, updating, selecting using this method would be much
> appreciated. Also if there is another way to go about this, that
> would be cool as well. Thanks.
Received on Wed Sep 18 2002 - 10:30:32 CDT