Oracle ODP.NET 读取 数据库表结构时 COLUMN_EXPRESSION 等LONG类型字段为空,
比如:
SELECT * FROM ALL_IND_EXPRESSIONS
读取时 COLUMN_EXPRESSION 为空值,但是System.Data.OracleClient连接方式是可以读出来的。
处理方法:
((Oracle.ManagedDataAccess.Client.OracleCommand)command).InitialLONGFetchSize = -1;
还有一个类似的属性:
((Oracle.ManagedDataAccess.Client.OracleCommand)dbCommand).InitialLOBFetchSize
https://docs.oracle.com/cd/E85694_01/ODPNT/CommandInitialLONGFetchSize.htm
https://blogs.oracle.com/oraclemagazine/post/serving-winning-lobs