5 Replies Latest reply on Jul 10, 2012 3:43 PM by ChrisJenkins-Oracle

    [TimesTen]TT2778: Cannot infer type of parameter from its use


      On Timesten [[TimesTen ] the below query results in error TT2778.

      SELECT COUNT(1) cnt123 FROM DUAL WHERE %Var1String LIKE %Var2String,

      Here both Var1String and Var2String are variables of String type.

      Error Trace:
      Caused by: java.sql.SQLException: [TimesTen][TimesTen ODBC Driver][TimesTen]TT2778: Cannot infer type of parameter from its use -- file "saCanon.c", lineno 16963, procedure "inferExprTNLike()"
      at com.timesten.jdbc.JdbcOdbc.createSQLException(JdbcOdbc.java:3287)
      at com.timesten.jdbc.JdbcOdbc.standardError(JdbcOdbc.java:3436)
      at com.timesten.jdbc.JdbcOdbc.standardError(JdbcOdbc.java:3401)
      at com.timesten.jdbc.JdbcOdbc.SQLPrepare(JdbcOdbc.java:2285)
      at com.timesten.jdbc.JdbcOdbcPreparedStatement.<init>(JdbcOdbcPreparedStatement.java:194)
      at com.timesten.jdbc.JdbcOdbcConnection.prepareStatement(JdbcOdbcConnection.java:342)

      Any pointer will be of great help.

      Thanks and Regards,