Though I've never used oraclecursor with iBatis, I'll dare to note that
from the image attached 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 ?,?... ).
On Fri, Aug 21, 2009 at 8:18 PM, M V Chetan <chetan.minaj...@tcs.com> wrote:
> Hi, I'm facing certain problems in getting my ibatis mapping to work with
> an oracle stored function Here is my mapping
> ------------------------------
>
> { ? = call PKG_SEARCH_LIST.F_COMPANY_LIST(?,?,?,?,?,?,?,?) }
> ------------------------------
> The error that I get is * PLS-00306: wrong number or types of arguments in
> call to 'F_COMPANY_LIST' ORA-06550: line 1, column 7: PL/SQL: Statement
> ignored * The stored function is as follows
> ------------------------------
> * CREATE OR REPLACE PACKAGE BODY PKG_SEARCH_LIST AS FUNCTION
> F_COMPANY_LIST(p_Company varchar2,p_EntFromDt date, p_EntToDt date,
> p_LstModFromdt date, P_LstModToDt date, p_TransStatus varchar2, p_sort
> varchar2, p_QueryType varchar2) RETURN pkg_crs_util.ref_cursor IS ret_cursor
> pkg_crs_util.ref_cursor; BEGIN OPEN ret_cursor for select 1 parent_flg,
> 'Company1'company, null active_status ,null role, null security, null
> Deal_Fr_Dt, null Deal_To_Dt, null Deal_Title, null Deal_type from dual union
> select 0 parent_flg , 'Company1' company, 'Y' active_status ,1 role, '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 where I am going wrong? Regards, Chetan
> ------------------------------
> View this message in context: Problem calling Stored function in
> Oracle<http://www.nabble.com/Problem-calling-Stored-function-in-Oracle-tp25082929p25082929.html>
> Sent from the iBATIS - User - Java mailing list
> archive<http://www.nabble.com/iBATIS---User---Java-f370.html>at Nabble.com.
>
