postgreSQL transaction

<select id="insert" parameterType="InfoVO" resultType="egovMap">
	SELECT 프로시저명(#{blName},#{admId})	     
</select>

프로시저에서 새롭게 매개변수의 변수명 설정하는 느낌

CREATE OR REPLACE FUNCTION 스키마.프로시저명(_bcode character varying, _amdin character varying)
 RETURNS void
 LANGUAGE plpgsql
AS $function$

	BEGIN
	--시작
	END;
$function$
;

delete postgreSQL 트랜잭션 오류가 발생하면 롤백...

	<select id="delete">

		BEGIN;
			DELETE FROM area_side WHERE area_code IN (SELECT area_idx FROM area WHERE pl_idx = #{plIdx}::integer);
		    DELETE FROM area WHERE pl_idx = #{plIdx}::integer;
		    DELETE FROM info WHERE pl_idx = #{plIdx}::integer;

			EXCEPTION WHEN OTHERS THEN
			ROLLBACK;

		COMMIT;

	</select>