I have this sql in an OracleDataSet - SELECT Trunc( :CARR_ID ) CARR_ID, ST.ST_ID
FROM ST, DUAL
:CARR_ID is defined as an integer. In the fields editor, CARR_ID is defined as an integer. When I activate the query using MIDAS, I get this error 'dstAUTH_ST: Type mismatch for field 'CARR_ID', expecting: Integer actual: Float'.
How can I get rid of this error message?
Thanks