Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Using LOB or CLOB datatype with ASP
Tom McClelland wrote:
>
> C Chang <cschang_at_maxinter.net> wrote in message news:<3C635EB2.6641_at_maxinter.net>...
> > I am going to design a table including LOB or CLOB data. My WEB appl
> > is designed with ASP code. Does the MS ODBC or OLEDB driver can handle
> > such datatype? Thanks
> >
> > C Chang
>
> The ODBC driver does, but make sure that none of your LOB/CLOB have
> names such as "COMMENT" which are Oracle reserved words. These do not
> work even if you quote them (certainly parameterised inserts don't),
> because the internal driver mechanism for CLOB does not quote them
> even if you do. (As far as I can make out)
>
> Regards
>
> Tom
Thanks, Tom. One extra question. Then on ASP site, which type of
datatype (ad... ) matches the CLOB or LOB.
C Chang Received on Fri Feb 08 2002 - 23:19:23 CST