I have query something like this:
Select t1.col1, t2.col2,
>From table1 t1
Inner join table2 t2 ON t1.id = t2.id
Where to_num(t1.col3) = 2008 <--this will be dynamic in iBatis
I tried this code using Oracle Sql Developer and it works fine.
Now same code when i try in Ibatis
I have query something like this:
Select t1.col1, t2.col2,
>From table1 t1
Inner join table2 t2 ON t1.id = t2.id
Where to_num(t1.col3) = #Year# <--Year is a property whose datatype
is int
Ibatis keeps on complaining about 'to_num' function:
[System.Data.OracleClient.OracleException] = {"ORA-00904: \"TO_NUM\":
invalid identifier\n"}
Any suggestions?
--
View this message in context:
http://www.nabble.com/Oracle-query-tp25068034p25068034.html
Sent from the iBATIS - User - Cs mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-cs-unsubscr...@ibatis.apache.org
For additional commands, e-mail: user-cs-h...@ibatis.apache.org
