Re: xml in oracle 8i and multiple varchar2 fields

Well, in this case you can try using method Oracle itself uses for presenting stored programs sources. For example, create the following table:

table xmldocs (doc_id        number(10,0) primary key,
                      doc_name  varchar2(128) not null,
                      doc_part    varchar2(2000),
                      part_seq    number(10,0) not null -- you may want to index this column
                     );

and then break your XML document into chunks of 2000 chars each and insert them into xmldocs, incrementing part_seq by 1 for each new chunk (start with 1 or whatever). To reassemble the document, select doc_part from xmldocs where doc_id = :id -- or doc_name = :name  order by part_seq
and combine individual chunks received. Obviously, there is no easy way of updating the document rather than deleting original and reinserting new copy under the same id/name.

hth.

--
Vladimir Zakharychev (bob@dpsp-yes.com)                http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.


"John" <jriker1_at_yahoo.com> wrote in message news:e6bb5a8d.0209191335.5ecc4894_at_posting.google.com...


> In CF.

>

> JR

>

> "Vladimir M. Zakharychev" <bob_at_dpsp-yes.com> wrote in message

news:<ambp4g$ld7$1_at_babylon.agtel.net>...


> > > 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.

> >

> > No, it's not there in 8i. By saying that working with CLOBs is complicated

> > you mean it's complicated in CF or in Oracle? I would object if second, but

> > have no idea if it is really so in CF...