Re: Problem calling Stored function in Oracle

2009-08-24 Thread M V Chetan
I see that parametermap property for the ORALECURSOR is the last one in the map. But it must be the first one (order parameter map properties must match order of ?,?... ). -- View this message in context: http://www.nabble.com/Problem-calling-Stored-function-in-Oracle-tp25082929p25116009.html Sent from

Re: Problem calling Stored function in Oracle

2009-08-21 Thread happentrack
u may want to double check that. I would have been to nice to get clear message from IBatis if a Bad JDBCType is passed. I don't know if there is reason why it allows passing in a JDBCType that is not in a known Set. -- View this message in context: http://www.nabble.com/Problem-calling-

Re: Problem calling Stored function in Oracle

2009-08-21 Thread Nicholoz Koka Kiknadze
e, 'xyz' > security, sysdate Deal_Fr_Dt, sysdate Deal_To_Dt, 'Mydeal' > Deal_Title,'Financing' Deal_type from dual order by parent_flg desc ; RETURN > ret_cursor; END; END PKG_SEARCH_LIST; * > ------ > Can someone please point out

Re: Problem calling Stored function in Oracle

2009-08-21 Thread jhking
an oracle stored function -- View this message in context: http://www.nabble.com/Problem-calling-Stored-function-in-Oracle-tp25082929p25085090.html Sent from the iBATIS - User - Java mailing list archive at Nabble.com. - To u

Problem calling Stored function in Oracle

2009-08-21 Thread M V Chetan
7;Mydeal' Deal_Title,'Financing' Deal_type from dual order by parent_flg desc ; RETURN ret_cursor; END; END PKG_SEARCH_LIST; Can someone please point out where I am going wrong? Regards, Chetan -- View this message in context: http://www.nabble.com/Problem-calling-Sto