Re: Need help with clob datatype and ADO

Actually clob can hold 4 gig. No reason one can't use them for a web server.
Jim

"Jan Barenholdt" <se_at_reply_to.dk> wrote in message news:3da73662.14733462_at_news.cybercity.dk...
> Hi Marc
>
> A clob type can hold 2Gb of data, that amount of data is normaly
> incompatibel with web servers and OSs, you can use a varchar2 type, it
> can hold max 4000 characters or maybee a bfile type, that is a type
> that holds the location of a file (why there is a bfile type I dont
> know, IMHO a varchar2 type with the location 'C:\myfile' could do it)
>
> good luck Jan
>
>
> On Fri, 11 Oct 2002 00:42:23 -0400, "Marc Robitaille"
> <marcmarie_at_videotron.ca> wrote:
>
> >Hello,
> >
> >We bought an application which functions with SQLServer 2000. This
> >application is a Web application and uses ADO with COM+ objects. The
 COM+
> >objects are written in VB whereas the Web part is in ASP. We wish to make
> >function this application with our Oracle 8i server. In the data base
> >SQLServer 2000, there are several fields of the Text datatype. In the
 update
> >with Oracle, these fields became clob. The application functions
 correctly
> >except for the fields clob. Recordset contains only the first 255
> >characters!!!!!.
> >A fellow-member at works suggested me changing the client cursor to a
> >server cursor. When we roll the application in debug, the contents of the
> >field contain more than 255 characters but as it is a Web application, at
> >the end of each request to the server, the connection is closed.
 Therefore,
> >we lose information. I also read that certain Oracle datatypes are not
> >supported by ADO!!!!!
> > Is there somebody who have an idea on the way of obtaining the contents
 of
> >this field with ADO or perhaps we do not use the good datatype field? ?
> >
> >Thank you very much
> >excuse my bad english
> >
> >Marc Robitaille
> >
> >
>
Received on Sat Oct 12 2002 - 10:26:52 CEST