CLOB to String conversion in ASP

From: Christophe Lecas <christophe_lecas_at_intuit.com>
Date: Wed, 29 Dec 1999 10:06:01 -0800
Message-ID: <84dihv$5i9$1@news.intuit.com>

I'm retieving a CLOB field from an Oracle 8i database and I just want to write the content on my page. The code is:

<%
Set OraSession = CreateObject("OracleInProcServer.XOraSession") Set OraDatabase = OraSession.OpenDatabase("dbname", "login/password", 0) Set OraDynaset = OraDatabase.CreateDynaset("SELECT clobfield FROM mytable WHERE ..... ",0)
%>

The type name for the clobfield is IOraClob.

The problem is that I don't know how to convert this IOraClob to a string in order to do a response.write() of it.

<% response.write(OraDynaset.fields("emailmessagebody").value) %> returns an error
"Missing Default property"
<% response.write(CStr(OraDynaset.fields("emailmessagebody").value)) %> returns an
error "Object does not support this property or method"

What is the best way to convert this IOraClob into a string ?

Thanks Received on Wed Dec 29 1999 - 12:06:01 CST