ibatis select 로 키값 가져와서 인서트

<insert id="OasisSyncDAO.insertAcsAllow" parameterClass="oasisVO">

          <selectKey resultClass="int" keyProperty="allowId">

                                SELECT NVL(MAX(ALLOW_ID),0)+1 AS ALLOW_ID  FROM OASIS_ACCESS_ALLOW

                     </selectKey>

          <![CDATA[

 

           ) VALUES (

             #allowId#,

             #serviceKey#,

             'KEY',

             'REST',

             '',

             #limitCnt#,

             #startDt#,

             #endDt#,

         )             

          ]]>

    </insert>