"CME" <support_at_cmesys.demon.co.uk> wrote in message
news:999619263.17154.0.nnrp-13.c2de4217_at_news.demon.co.uk...
> Dear all,
>
> Sorry for this question, but I need to release in the next week.
>
>
> We have an internally developed reportwriter that stores its reports as
XML
> in a database. Historically this data was stored in a column of type LONG.
>
> The average length of characters is about 100,000.
>
>
> We cannot write this amount of text to the field even when trying to BIND
> the field.
>
> I have also tried a CLOB, but VB does not support this datatype via ADO..
>
>
> So if anyone could tell me how the hell I am ameant to store this data
(and
> initially populating the table with our default reports), I would be very
> happy.
>
>
> I have never had any problems using Sybase or SQL Server, but I have been
> round in circles for the last two days.
>
> Information:
>
> We are using Oracle 8i standard edition with ADO 2.6 to VB 6 (sp 5).
>
> An example of the SQL would be useful.
>
>
> Matt.
>
>
Received on Tue Sep 04 2001 - 16:02:16 CDT
