Hi Everyone,
Bit of a strange one, that I've not encountered before and is only affecting one view/sql.
I have an oracle view, all of the data is displayed correctly, except one Column (in VS).
If I run the SELECT SQL in SQL Developer I get data in all columns, however if I run the exact same SQL in Visual Studio all the data is displayed, except this one column which comes out as all NULL values (in all rows).
Internal to the VIEW is SUBSTR, however the data resolves to VARCHAR2(200).
Using Visual Studio 2013, ODP.NET, Managed Driver.
Has anyone seen anything like this before?
What I have tried:
Recreating the VIEW.
Running as a Query in the Server Explorer and as DataSource DataTable/Adapter.