2 Replies Latest reply on Feb 21, 2018 9:52 AM by Paulus Paulus

    ORACLE NUMBER datatype is converting to BIGDECIMAL(1) As default using teiid designer

    Paulus Paulus Newbie

      Dear All,

       

      we able to import all the ORACLE TABLES to eclipse using JDBC database connection teiid designer.

       

      Teiid  designer is converting all NUMBER datatype to BIGDECIMAL(1)  in source as default. Due to this reason, we are facing problem in the deployment of VDB .

       

      1) Any other options to  change in the Global setting  to BIGDECIMAL without precision 1 ?

      2) Second, FIXED LENGTH of NUMBER datatype ORACLE  is 7 not showing in VDB XML? How to fix the issue? please see the examples

       

      Example:-

      TESTING bigdecimal(1) OPTIONS(NAMEINSOURCE '"testing', NATIVE_TYPE 'NUMBER', FIXED_LENGTH 'TRUE'),

       

      Thanks for helping us.