C# - 如何获取 oracle long 原始类型值 [英] C# - How to get oracle long raw type value

问题描述

如何使用 C# 获取 long 原始类型值?

How to get long raw type value with C#?

推荐答案

你还没贴代码，不知道你知道多少.我将假设您已经了解如何使用 OracleDataReader 执行查询并获取结果集.

Since you haven't posted any code, I don't know how much you know. I'm going to assume you already understand how to execute a query and get back a result set using OracleDataReader.

LONG 和 LONG RAW 列有一个问题.您必须将 OracleCommand 的 InitialLONGFetchSize 属性设置为非零值.

There is one gotcha with LONG and LONG RAW columns. You must set the InitialLONGFetchSize property of your OracleCommand to a non-zero value.

InitialLONGFetchSize 的默认值为零，这意味着不会检索 LONG 或 LONG RAW 列的数据.如果将其设置为 -1，则将检索所有数据.对于较大的值，您可能不想这样做.如果您将其设置为大于零的任何值，这就是最初获取和缓存的字节数.

The default value of InitialLONGFetchSize is zero, which means no data will be retrieved for LONG or LONG RAW columns. If you set it to -1, all data will be retrieved . You might not want to do this for large values. If you set it to anything above zero, that's how many bytes will be intially fetched and cached.

您应该阅读文档 对于 InitialLONGFetchSize，因为还有一些其他的细节你需要知道.

You should read the documentation for InitialLONGFetchSize, because there are some other details you need to know.

这篇关于C# - 如何获取 oracle long 原始类型值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！