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.
There is one gotcha with LONG and LONG RAW columns. You must set the InitialLONGFetchSize
property of your OracleCommand
to a non-zero value.
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.
You should read the documentation for InitialLONGFetchSize
, because there are some other details you need to know.
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…