Re: CLOB datatype

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Fri, 1 Dec 2000 09:55:08 -0000
Message-ID: <907shu$ns9$1@soap.pipex.net>

This information isn't in fact the complete story.

The knowledge base article you describe refers not to asp/ado but to the Microsoft Drivers (both ODBC and OLEDB). It most definitely does not apply to the Oracle supplied drivers (at least for ODBC).

In addition Oracle Objects is a perfectly valid connection strategy for ASP though I suspect that examples to get you going are ratherthin on the ground.

I cannot see anything in the ado documentation that details what field types are supported, perhaps I missed something in the ado docs to which you refer us.

It therefore looks to me as though retrieval of LOB data *ought* to be possible in an ASP page. You would need to use either the Oracle Drivers or OO40.

The original post did not include any code. If this were posted it might be possible to provide a few more pointers.

regards

--
Niall Litchfield
Oracle DBA
Audit Commission UK



<craig_comstock_at_my-deja.com> wrote in message
news:903scb$jtn$1_at_nnrp1.deja.com...


> CLOBs are not really supported via ASP/ADO. At the very least they will

> be truncated to 4000 chars (I think).

>

> http://support.microsoft.com/support/kb/articles/Q244/6/61.ASP

>

> also look here...

>

> http://msdn.microsoft.com/library/default.asp?

> URL=/library/psdk/dasdk/mdao2of9.htm

>

> I had the same problem using Cold Fusion, then tried ASP, then finally

> went back to Cold Fusion.

>

> http://x74.deja.com/threadmsg_ct.xp?

> AN=699250522.1&mhitnum=1&CONTEXT=975533251.1918435369

>

> Hope that helps...

> In article <3a1cfd0f$1_at_news.cablecat.com>,

>   "Antonio Palacin" <antonio.palacin_at_fisystem.com> wrote:

> >

> >     Hello,

> >

> >     I'm working with HTML/ASP against Oracle 8i. When I try to get

 the data


> > stored in a CLOB datatype field from HTML, I get nothing. This

 happens when


> > the field has more than one line of data stored; but when I

 originally only


> > inserted one line, it works!

> >

> >     Can anyone help me?

> >

> >     Thanks,

> >

> >     Antonio

> >

> >

>

>

> Sent via Deja.com http://www.deja.com/

> Before you buy.

Received on Fri Dec 01 2000 - 03:55:08 CST