Re: Storing large text fields ---- urgent help required.

Have a look at AppendChunk and GetChunk methods in MSDN library. I'm no VB programmer myself, just heard them talking. Using oracle 7.3.4, dont know what ado provider they use i think msdaora, but could also have been be the microsoft one.

Bye,

Erik de Jong.

CME wrote:

> 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 - 17:26:55 CDT