请问这个存储过程哪里不对啊。。。DRAW_CURRENT这张表中咋无记录、存过过程明明运行成功了

Question

create or replace procedure PRO_DRAW  is
    v_DrawCount VARCHAR(100);
BEGIN  BEGIN
    SELECT COUNT(*) INTO v_DrawCount  FROM DRAW_TRANS  T WHERE T.ACTIVITY = 0; 
       INSERT INTO DRAW_CURRENT
            (SERIAL_ID,
             ACCOUNT_NAME,
             AMOUNT,
             CREATE_DATE,
             RATE_ID,
             PLACE_ID,
             BANK_TYPE,
             BANK_ACCOUNT,
             BANK_ACCOUNTNAME,
             DRAW_TYPE,
             STATE
            )
         SELECT 
             X.SERIAL_ID, 
             X.OBJECT_ACCOUNT,
             X.AMOUNT,
             X.CREATE_DATE,
             X.RATE_ID,
             X.PLACE_ID,
             X.BANK_TYPE,
             X.BANK_ACCOUNT,
             X.BANK_ACCOUNTNAME,
             X.DRAW_TYPE,
             X.ACTIVITY
         FROM DRAW_TRANS X WHERE X.DRAW_TYPE = 8 AND X.ACTIVITY = 0; 
   EXCEPTION
      WHEN OTHERS THEN  
      ROLLBACK;
  END
  COMMIT; 
END PRO_DRAW;

Answer 1

先运行下面的sql，看是否有记录
SELECT  
  X.SERIAL_ID,  
  X.OBJECT_ACCOUNT,
  X.AMOUNT,
  X.CREATE_DATE,
  X.RATE_ID,
  X.PLACE_ID,
  X.BANK_TYPE,
  X.BANK_ACCOUNT,
  X.BANK_ACCOUNTNAME,
  X.DRAW_TYPE,
  X.ACTIVITY
  FROM DRAW_TRANS X WHERE X.DRAW_TYPE = 8 AND X.ACTIVITY = 0;  

Answer 2

那再运行INSERT INTO DRAW_CURRENT
  (SERIAL_ID,
  ACCOUNT_NAME,
  AMOUNT,
  CREATE_DATE,
  RATE_ID,
  PLACE_ID,
  BANK_TYPE,
  BANK_ACCOUNT,
  BANK_ACCOUNTNAME,
  DRAW_TYPE,
  STATE
  )
  SELECT  
  X.SERIAL_ID,  
  X.OBJECT_ACCOUNT,
  X.AMOUNT,
  X.CREATE_DATE,
  X.RATE_ID,
  X.PLACE_ID,
  X.BANK_TYPE,
  X.BANK_ACCOUNT,
  X.BANK_ACCOUNTNAME,
  X.DRAW_TYPE,
  X.ACTIVITY
  FROM DRAW_TRANS X WHERE X.DRAW_TYPE = 8 AND X.ACTIVITY = 0;

Answer 3

SELECT COUNT(*) INTO v_DrawCount FROM DRAW_TRANS T WHERE T.ACTIVITY = 0;这句在你这个procedure中有啥用？

Answer 4

运行这段SQL后表中有记录的，但是运行存储过程就不行了