TMP_OEP_CNT int;   

 select count(*) into TMP_OEP_CNT from cm_otp where USE_FL = 'Y';

  if TMP_OEP_CNT > 0 then
    FOR OEPList IN (
      SELECT OEP.OTP_PASSWORD, OEP.AUTH_PERIOD
      FROM (
        SELECT  OTP_PASSWORD, to_char(REG_DT,'YYYYMMDD')+7 as AUTH_PERIOD -- '+7'은 AGENT_OEP_OFF_AUTH_PERIOD 기간을 의미
        FROM CM_OTP
        WHERE USE_FL = 'Y'
        ORDER BY OTP_SQ DESC
      ) OEP
      WHERE ROWNUM=1
    ) LOOP
       TMP_QUERY := ' INSERT INTO TempVersion SELECT ''UserOEPPW'' AS CCF_FIELD, ''' || OEPList.OTP_PASSWORD || ''' AS CCF_VALUE FROM DUAL ';
       EXECUTE IMMEDIATE TMP_QUERY;
       TMP_QUERY :=  'INSERT INTO TempVersion SELECT ''AGENT_OEP_OFF_AUTH_PERIOD'' AS CCF_FIELD, ''' || OEPList.AUTH_PERIOD || ''' AS CCF_VALUE FROM DUAL ';
       EXECUTE IMMEDIATE TMP_QUERY;
    END LOOP;
  end if;

이런 프로시저를 변환하려 하는데

 DECLARE @TMP_OEP_CNT   INT
 
 SELECT @TMP_OEP_CNT = COUNT(*)
 FROM CM_OTP
 WHERE USE_FL = 'Y';
 
 IF @TMP_OEP_CNT > 0
  BEGIN
  
   EXEC();
  
  END

if문 사용하는 부분과 loop 에서 뭘 써도 오류가 나서 이런 상태입니다...

마이그레이션을 잘 못하는 신입에게 도움 부탁드립니다 ㅠㅠ...