inline parameters for SP

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

inline parameters for SP

JaiGharge
Hi,

I am new to iBatis, and I am facing some issues while calling a <procedure> using inline parameters.
Below is the Java code:

CommonServiceDetail commonServiceDetail = (CommonServiceDetail)sqlMapClient.queryForObject("EasyGo.getCommonServiceSP", "F");

Below is the SQL Map:

<procedure id="getCommonServiceSP" parameterClass="string" resultClass="com.axiom.it.easygo.dto.CommonServiceDetail"> 
       { call PKG_CFS_COMMON_SERVICES.USP_GET_CFS_COMMON_SERVICES(
        #commonServiceId,jdbcType=NUMERIC,mode=OUT#,
        #serviceCode,jdbcType=VARCHAR,mode=IN#,
        #serviceDescription,jdbcType=VARCHAR,mode=OUT#,
        #remarks,jdbcType=VARCHAR,mode=OUT#,
        #active,jdbcType=VARCHAR,mode=OUT#,
        #createdUserId,jdbcType=NUMERIC,mode=OUT#,
        #createdDate,jdbcType=DATE,mode=OUT#,
        #updatedUserId,jdbcType=NUMERIC,mode=OUT#,
        #updatedDate,jdbcType=DATE,mode=OUT#,
        #attribute1,jdbcType=VARCHAR,mode=OUT#,
        #attribute2,jdbcType=VARCHAR,mode=OUT#,
        #attribute3,jdbcType=VARCHAR,mode=OUT#,
        #attribute4,jdbcType=VARCHAR,mode=OUT#,
        #attribute5,jdbcType=VARCHAR,mode=OUT#,
        #attribute6,jdbcType=VARCHAR,mode=OUT#,
        #attribute7,jdbcType=VARCHAR,mode=OUT#,
        #attribute8,jdbcType=VARCHAR,mode=OUT#,
        #attribute9,jdbcType=VARCHAR,mode=OUT#,
        #attribute10,jdbcType=VARCHAR,mode=OUT#,
        #attribute11,jdbcType=VARCHAR,mode=OUT#,
        #attribute12,jdbcType=VARCHAR,mode=OUT#,
        #attribute13,jdbcType=VARCHAR,mode=OUT#,
        #attribute14,jdbcType=VARCHAR,mode=OUT#,
        #attribute15,jdbcType=VARCHAR,mode=OUT#,
        #dataSecurity,jdbcType=VARCHAR,mode=OUT#)
        }  
 </procedure> 

My input to procedure is String and I have tried parameterClass = "java.lang.String" OR parameterClass = "String" OR parameterClass = "string" but still i am getting error mentioned below:

11:54:33,936 ERROR [STDERR] com.ibatis.common.jdbc.exception.NestedSQLException:  
--- The error occurred in sqlmap.xml.  
--- The error occurred while applying a parameter map.  
--- Check the EasyGo.getCommonServiceSP-InlineParameterMap.  
--- Check the statement (update procedure failed).  
--- Cause: java.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'USP_GET_CFS_COMMON_SERVICES'

I am stuck badly in this issue, please help.

Thanks,
Jai Gharge
Loading...