Inferring Data Type from Parameters
Consider this statement:
SELECT :a FROM dual;
TimesTen cannot infer the data type of parameter a
from the query. TimesTen returns this error:
2778: Cannot infer type of parameter from its use The command failed.
Use the CAST
function to declare the data type for parameters:
SELECT CAST (:a AS NUMBER) FROM dual;