mybatis에서 프로시저 사용해서 숫자 하나 리턴받을라는데
There is no setter for property named 'ress' in 'class java.lang.Integer'
integer 클래스에 ress setter가 없다고 지롤해요
어떻게 받을수 있죠
xml
<select id="proc" statementType="CALLABLE" resultType="java.lang.Integer">
{call delcontent(#{num}, #{ress, mode=OUT, jdbcType=INTEGER})}
</select>
프로시저
create or replace PROCEDURE "DELCONTENT"
(
varnum IN number,
res OUT number
) AS
temp number;
BEGIN
SELECT count(num) INTO temp FROM board WHERE parent = varnum;
IF temp = 0 THEN
DELETE FROM board WHERE num = varnum;
res := 1;
ELSE
UPDATE board
SET active = 0, title='삭제된 게시글', content='삭제된 게시글', author='삭제'
WHERE num = varnum;
res := 2;
END IF;
END delcontent;
머가 잘못된거죠
제 머리통이 잘못된거 말구요
댓글 0