<procedure id="StaffAppraisal.updateKra" parameterClass="map">
<![CDATA[
{
#p_return_val,jdbcType=DECIMAL,mode=OUT# = call appraisal.update_kra(
#p_staff_id,jdbcType=VARCHAR,mode=IN#,
#p_appraisal_seq,jdbcType=VARCHAR,mode=IN#,
#p_session_code,jdbcType=VARCHAR,mode=IN#,
#p_year,jdbcType=VARCHAR,mode=IN#,
#p_kra,jdbcType=VARCHAR,mode=IN#,
#p_errmsg,jdbcType=VARCHAR,mode=OUT#
)
}
]]>
</procedure>
Dev info :
Codename= APAR
DB = Oracle 10G
Contoh DAO (tiada kena mengena dengan map di atas):
...
public String sendEmail (String formOwnerId, String emailType, String refCode)
{
String errorMesej = null;
Map<String,String> param = new HashMap<String,String>();
param.put("p_staff_id" , formOwnerId);
param.put("p_email_type", emailType);
param.put("p_ref" , refCode);
param.put("p_errmsg" , refCode);
this.getSqlMapClientTemplate().update("EMAIL.sendEmail", param);
errorMesej = param.get("p_errmsg");
return errorMesej;
}
...
How to call an Oracle 10G procedure in ibatis 2?
No comments:
Post a Comment