I am using the System.Data.OracleClient namespace to call on an Oracle stored
procedure that runs a query and returns a ref cursor. One of the fields
returned by the query is a LONG RAW. When I call OracleDataReader.Read(), I
get the following exception:
ORA-01406: fetched column value was truncated
I have not been able to find any information on how to resolve this. I
tried switching to Oracle's ODP.NET provider, but it seems to have problems
of its own. Any help would be greatly appreciated. Here is some of my code
Dim myCommand As OracleCommand
Dim myReader As OracleDataReader
'I set up the command and reader here
myReader = myCommand.ExecuteReader()
While myReader.Read() ' <--- this throws the exception
End While
I only see the problem when calling on stored procedures. If run the same
SELECT query from the application, it works fine.