5 Replies Latest reply on Jan 21, 2016 10:44 AM by Steven Hawkins

    How to convert nvarchar2 to string datatype in view using DDL approach

    govindaraj s Novice



      I have created view in view model (using DDL approach) and pointing to oracle table, In the oracle table, the column data type as nvarchar2, but I need the same column and type as String in view, it does not allow me to create view with column type as String, it raise the below error, How to convert nvarchar2 to String in view?


      TEIID31080 Viewmodel.testview validation error: The definition for Viewmodel.testview has the wrong type for column 1. Expected string, but was object


      Note: In Model Approach (Teiid Designer), Teiid Designer is converted nvarchar2 to String automatically when we import the schema from Oracle


      Thanks & Regards

      Govindaraj Sanjeevi