insert selectKey ibatis
<insert id="SmsDAO.registSmsNuri" parameterClass="smsConnVO" >
<selectKey resultClass="int" keyProperty="nuriSeq">
<![CDATA[ SELECT nuri_user.msg_data_seq.nextval FROM DUAL ]]>
</selectKey>
<![CDATA[
insert into nuri_user.msg_data
(msg_seq,
req_date,
cur_state,
call_to,
call_from,
sms_txt,
msg_type,
user_id,
site_cd
)
values
(#nuriSeq#,
sysdate,
#curState#,
#callTo#,
#callFrom#,
#text#,
#msgType#,
#userID#,
'01'
)
]]>
</insert>