Search code examples
oracleodata

oData service not returning CLOB field

I have a simple Oracle table with 3 fields: ID (int), Name (nvarchar), and configJSON (CLOB).

The configJSON field is over 10,000 characters.

I am trying to use this table in an oData web service using entity framework. I do not get an error message, but the response is simply blank. When I remember the CLOB column I see the other 2 data fields so I think the issue relates to the large CLOB field. I am not tied to that particular data type but I thought that was the best to use since my field is so large.

What is the best way to return a large data field within an oData web service?

Solution

  • I was able to resolve the issue by changing the field type to a LONG.