I am trying to connect to an Oracle 9i database through thingworx.connection seems successful and when I run a service to get the records I am getting the data but few columns are blank. The datatype for those columns which are blank is varchar2
Solved! Go to Solution.
It seems only numeric data is being displayed. Could you please check if the Datashape linked to the result Infotable has the appropriate base types for the field definitions?
I have checked the Data Shape looks good and i have removed the DS and checked still the same issue. I have the same table in Oracle 11.2 which works fine but in oracle 9i has issue. Checked permissions for the user connecting to DB and it has same access.
I don't know what exactly the issue is, but I would suggest checking those three things: