ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From M V Chetan <chetan.minaj...@tcs.com>
Subject Problem calling Stored function in Oracle
Date Fri, 21 Aug 2009 16:18:28 GMT

Hi,

I'm facing certain problems in getting my ibatis mapping to work with an
oracle stored function


Here is my mapping
http://www.nabble.com/file/p25082929/query1.jpg 




	
		
		
		
		
		
		
		
		
				
	
	
	
    
        
        
        
        
        
        
		        
				
        
        
             
    

 
 	 { ? = 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: http://www.nabble.com/Problem-calling-Stored-function-in-Oracle-tp25082929p25082929.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.

Mime
View raw message