hi,

me again - pulling out my hair in stress

interesting idea - created a table using a clob

create table master_elearning_control2
(elrn_id varchar2(12),
elrn_data clob,
elrn_datime varchar2(14),
constraint elrn2_id_key primary key (elrn_id)
);

elrn_data to hold the xml structure.... - using this i encountered the following message

"ORA-01704: string literal too long"

had a look across various newsgroups and this seems a well known problem - using ado on oracle, it look like the max size U can pass is 2000chr with oracle 7 (& 4k with oracle 8). event though a clob/blob etc can be 4 gig.

see ms knowledgebase http://support.microsoft.com/default...;EN-US;q233515

I think I could try stored-procedures and passing the longfield etc etc but am unsure that this will really get me anywhere fast....

Like you suggested I would love to put the data on the same server as the webserver - I cannot - Our DB is oracle running on an IBM-SP2. (our SP2 being in 3 stacks (8 foot high - huge!) and each stack being a rack of rs/6000's all running Aix....). Our webservers are multi-processor prolients running IIS.... We connect via the std oracle odbc drivers....

The db should handle the work, ditto IIS - I just think its the bandwidth across our lan and I expect to much of it?

The problem is that datasize and as xml structures are always whole-ly loaded and whole-ly saved, this causes the larger than necessary load on the lan etc.

I was brought into this a bit late but am now going to recommend that we do now work with and agency that produces application based on XML. This seems ludite and a retrograde step to me....

Thanks for the comments. anything else would be appreciated..........

AJP