Re: xml in oracle 8i and multiple varchar2 fields

I didn't know there was an xml datatype in 8i. Thought that was just 9. I am avoiding CLOB's because I'm using ColdFusion and working with CLOB's is complicated at best.

JR

jocave_at_yahoo.com (Justin Cave) wrote in message news:<233b7a65.0209180730.1b166103_at_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 - 19:30:05 CDT