存clob为空的值_EF + ODP.NET + CLOB =值不能为空 - 参数名称：byteArray？

Our project recently updated to the newer Oracle.ManagedDataAccess DLL's (v 4.121.2.0) and this error has been cropping up intermittently. We've fixed it a few times without really knowing what we did to fix it.

I'm fairly certain it's caused by CLOB fields being mapped to strings in Entity Framework, and then being selected in LINQ statements that pull entire entities instead of just a limited set of properties.

Error:

Value cannot be null.

Parameter name: byteArray

Stack Trace:

at System.BitConverter.ToString(Byte[] value, Int32 startIndex, Int32 length)

at OracleInternal.TTC.TTCLob.GetLobIdString(Byte[] lobLocator)

at OracleInternal.ServiceObjects.OracleDataReaderImpl.CollectTempLOBsToBeFreed(Int32 rowNumber)

at Oracle.ManagedDataAccess.Client.OracleDataReader.ProcessAnyTempLOBs(Int32 rowNumber)

at Oracle.ManagedDataAccess.Client.OracleDataReader.Read()

at System.Data.Entity.Core.Common.Internal.Materialization.Shaper`1.StoreRead()

Suspect Entity Properties:

'Mapped to Oracle CLOB Column'

Public Property LargeField As String

But I'm confident this is the proper way to map the fields per Oracle's matrix:

There is nothing obviously wrong with the generated SQL statement either:

SELECT

...

"Extent1"."LARGEFIELD" AS "LARGEFIELD",

...

FROM ... "Extent1"

WHERE ...

I have also tried this Fluent code per Ozkan's suggestion, but it does not seem to affect my case.

modelBuilder.Entity(Of [CLASS])().Property(

Function(x) x.LargeField

).IsOptional()

Troubleshooting Update:

After extensive testing, we are quite certain this is actually a bug, not a configuration problem. It appears to be the contents of the CLOB that cause the problem under a very specific set of circumstances. I've cross-posted this on the Oracle Forums, hoping for more information.

解决方案

We have this problem as well on some computers, and we are running the latest Oracle.ManagedDataAccess.dll (4.121.2.20150926 ODAC RELEASE 4).

We found a solution to our problem, and I just wanted to share.

This was our problem that occurred some computers.

Using connection As New OracleConnection(yourConnectionString)

Dim command As New OracleCommand(yourQuery, connection)

connection.Open()

Using reader As OracleDataReader = command.ExecuteReader()

Dim clobField As String = CStr(reader.Item("CLOB_FIELD"))

End Using

connection.Close()

End Using

And here's the solution that made it work on all computers.

Using connection As New OracleConnection(yourConnectionString)

Dim command As New OracleCommand(yourQuery, connection)

connection.Open()

Using reader As OracleDataReader = command.ExecuteReader()

Dim clobField As String = reader.GetOracleClob(0).Value

End Using

connection.Close()

End Using