5 Replies Latest reply on Jan 10, 2017 10:07 AM by rhn-engineering-rareddy

    teiid throwing teiid.api.exception.query.QueryResolverException

    kulbhushanc

      I am trying to fire query on oracle database trough teiid, I am using teiid admin api to deploy VDB.

      Query:

      insert into OraConnCDC.SYSTEM."SOURCE_DM"("SOURCE_SK","SOURCE_SHORT_DESC","SOURCE_LONG_DESC","SOURCE_HOME","DW_CREATE_DTM","UPDATE_BY","DW_UPDATE_DTM","CURRENT_IND") values ('4815','secured loans','Share Capital or Equity Shares','Home Insurance',TO_TIMESTAMP('16-DEC-16 09.53.31 AM'),'little_princess-angel@hotmail.com',TO_TIMESTAMP('16-DEC-16 09.53.31 AM'),'0');,

      in return teiid throwing exception:

      org.teiid.jdbc.TeiidSQLException: TEIID30068 Remote org.teiid.api.exception.query.QueryResolverException: TEIID30068 The function 'TO_TIMESTAMP('16-DEC-16 09.53.31 AM')' is an unknown form.  Check that the function name and number of arguments is correct.

       

      Thanks,

      Kulbhushan