如何使用 OleDb 读取 Oracle 中的 CLOB 列？

发布于 2024-08-27 03:08:59 字数 862 浏览 11 评论 0原文

我在 Oracle 10g 数据库上创建了一个具有以下结构的表：

create table myTable
(
id       number(32,0)      primary key,
myData   clob
)

我可以毫无问题地在表中插入行，但是当我尝试使用 OleDb 连接从表中读取数据时，出现异常。

这是我使用的代码：

using (OleDbConnection dbConnection = new OleDbConnection("ConnectionString"))
{
    dbConnection.Open();

    OleDbCommand dbCommand = dbConnection.CreateCommand();

    dbCommand.CommandText = "SELECT * FROM myTable WHERE id=?";
    dbCommand.Parameters.AddWithValue("ID", id);

    OleDbDataReader dbReader = dbCommand.ExecuteReader();
}

异常详细信息似乎指向不受支持的数据类型：

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

有谁知道如何使用 OleDb 连接读取此数据？

PS：本例中使用的驱动程序是微软的驱动程序。

原文

I have created a table on an Oracle 10g database with this structure :

create table myTable
(
id       number(32,0)      primary key,
myData   clob
)

I can insert rows in the table without any problem, but when I try to read data from the table using OleDb connection, I get an exception.

Here is the code I use :

using (OleDbConnection dbConnection = new OleDbConnection("ConnectionString"))
{
    dbConnection.Open();

    OleDbCommand dbCommand = dbConnection.CreateCommand();

    dbCommand.CommandText = "SELECT * FROM myTable WHERE id=?";
    dbCommand.Parameters.AddWithValue("ID", id);

    OleDbDataReader dbReader = dbCommand.ExecuteReader();
}

The exception details seems to point on an unsupported data type :

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

Does anyone know how I can read this data using the OleDb connection ?

PS : The driver used in this case is the Microsoft one.

分享到QQ

分享到微博