No. I don't get error message but i get the result back, it works perfectly
fine after i remove the 'to_num' function. And yeah col3 is valid column.
Sorry for misunderstanding.
Brian Elcock wrote:
>
> t1.col3 is a valid column?
>
> You get a complaint about the to_num function still when you remove it
> from the query? Your original error was:
>
> [System.Data.OracleClient.OracleException] = {"ORA-00904:
> \"TO_NUM\":invalid identifier\n"}
>
> I don't see how you could get the same error if to_num is no longer
> sent to the DB.
>
> Brian
>
> On Thu, Aug 20, 2009 at 1:06 PM, sanjeev40084<sanjeev40...@hotmail.com>
> wrote:
>>
>> Brian, i did not check the log..but even in iBatis
>>
>> when i change the query with the hard code value .e.g. '2008' after
>> removing
>> to_num function from the query, i get the result back. So i don't think
>> it's
>> access issue.
>>
>> Sanjeev
>>
>>
>>
>> Brian Elcock wrote:
>>>
>>> Hello Sanjeev
>>>
>>> Are you sure that the user that the IBatis application is using has
>>> access to that function? Are you logging the statement to see what is
>>> actually being sent to the database?
>>>
>>> Brian
>>>
>>> On Thu, Aug 20, 2009 at 12:08 PM, sanjeev40084<sanjeev40...@hotmail.com>
>>> wrote:
>>>>
>>>> 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
>>>>
>>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: user-cs-unsubscr...@ibatis.apache.org
>>> For additional commands, e-mail: user-cs-h...@ibatis.apache.org
>>>
>>>
>>>
>>
>> --
>> View this message in context:
>> http://www.nabble.com/Oracle-query-tp25068034p25068971.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
>>
>>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-cs-unsubscr...@ibatis.apache.org
> For additional commands, e-mail: user-cs-h...@ibatis.apache.org
>
>
>
--
View this message in context:
http://www.nabble.com/Oracle-query-tp25068034p25069216.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
