Hi everyone,

I've been developing an ASP/Oracle application and I'm
working with CLOB field, but I'm facing some problems.
when I try to retrieve CLOB data using "ADODB.Connection"
object and "connectionstring" method I get an error:
"Data Type is not Supported".
The only way that I could retrieve this data was
using "OracleInProcServer.XOraSession" object
and "DBCreateDynaset".

Question 1:
I would like to Know if It's possible to retrieve data from
CLOB field using "ADODB.Connection" object
and "connectionstring"
once I was told that the Dynaset is very old.

Question 2:
If it is possible to retrieve data using "ADODB.Connection"
object and "connectionstring" could you tell me how?


Question 3:
Another problem is that when I execute my application
the "DLLHOST.exe" consume 100% of my server CPU.
What this could be?

Thanks in advance,
Thiago.

hi,

did you ever resolve this problem. i'm new to oracle and one of the tables i'm trying to retrieve contains a clob datatype.

i get this error:

System.Data.OleDb.OleDbException: Unspecified error
Oracle error occurred, but error message could not be retrieved from Oracle.
Data type is not supported.

can you help me on this.

regards

ASP:
I cannot retrieve a CLOB given in output from an ORACLE stored procedure.
Could someone help me ?