Oracle存储过程失败，求大神指导。


--定义存储过程
CREATE OR REPLACE PROCEDURE TEST11 IS
  V_CONTRACT_HEADER_ID NUMBER;
BEGIN
  FOR CUR_TMP IN (SELECT * FROM LOAD_CON_CONTRACT_TAX_TEMP LCCTT) LOOP
   DBMS_OUTPUT.PUT_LINE(CUR_TMP.DESCRIPTION);
  DBMS_OUTPUT.PUT_LINE(CUR_TMP.CONTRACT_NUMBER);
   
      SELECT CCH.CONTRACT_HEADER_ID
        INTO V_CONTRACT_HEADER_ID
        FROM CON_CONTRACT_HEADERS CCH
       WHERE CCH.CONTRACT_NUMBER = CUR_TMP.CONTRACT_NUMBER
    --  DBMS_OUTPUT.PUT_LINE(CCH.CONTRACT_HEADER_ID);
    
  END LOOP;
END;--执行SQL
BEGIN
  TEST11;
END;
  
表CON_CONTACT_HEADERS结构：
CONTRACT_HEADER_ID NUMBER
COMPANY_ID NUMBER
CONTRACT_TYPE_ID NUMBER
CONTRACT_NUMBER VARCHAR2(30)
STATUS VARCHAR2(30)
DOCUMENT_NUMBER VARCHAR2(30)
DOCUMENT_DESC VARCHAR2(100)
DOCUMENT_DATE DATE
START_DATE DATE
END_DATE DATE
CURRENCY_CODE VARCHAR2(10)
AMOUNT NUMBER
UNIT_ID NUMBER
EMPLOYEE_ID NUMBER
PAYMENT_METHOD VARCHAR2(30)
PAYMENT_TERM_ID NUMBER
PARTNER_CATEGORY VARCHAR2(30)
PARTNER_ID NUMBER
VERSION_NUMBER VARCHAR2(30)
VERSION_DESC VARCHAR2(100)
NOTE VARCHAR2(2000)
PROJECT_ID NUMBER
CANCELED_BY NUMBER
CANCELED_DATE DATE
SUBMITED_BY NUMBER
SUBMITED_DATE DATE
CONFIRMED_BY NUMBER
CONFIRMED_DATE DATE
HOLDED_BY NUMBER
HOLDED_DATE DATE
FINISHED_BY NUMBER
FINISHED_DATE DATE
CREATED_BY NUMBER
CREATION_DATE DATE
LAST_UPDATED_BY NUMBER
LAST_UPDATED_DATE DATE 表LOAD_CON_CONTRACT_TAX_TEMP 结构
CONTRACT_NUMBER NUMBER
DESCRIPTION VARCHAR2(4000)
TAX_TYPE_ID VARCHAR2(4000)
TAX_TYPE_RATE NUMBER
AMOUNT NUMBER
TAX_AMOUNT NUMBER
OVER_AMOUNT NUMBER
USER_ID NUMBER报错信息
ORA-06550: line 2, column 3:
PLS-00905: object MASHEC.TEST11 is invalid
ORA-06550: line 2, column 3:
PL/SQL: Statement ignored