SQL> select sysdate from dual; SYSDATE -------------------------- 28-OCT-2010 10:27:26 SQL> show user USER is "TCONSUMER" SQL> sta CREATE_SKINID_ANSWERS_STG.sql PL/SQL procedure successfully completed. Table created. SQL> sta CREATE_STG_TABLES.sql PL/SQL procedure successfully completed. Commit complete. Table created. Table created. SQL> sta CREATE_INDEXES.sql PL/SQL procedure successfully completed. Commit complete. Index created. Commit complete. Index created. Commit complete. Index created. Commit complete. Index created. Commit complete. SQL> sta load_skinid_user_phone.sql 56 / Procedure created. SQL> sta load_skinideval.sql 34 / Procedure created. SQL> sta LOAD_SKINIDPURSTAGE.sql 36 / Procedure created. SQL> sta LOAD_REGIMENID_STG.sql Procedure created. SQL> sta LOAD_REG_STG.sql 30 / Procedure created. SQL> sta load_skiniduser.sql 154 / Warning: Procedure created with compilation errors. SQL> show error Errors for PROCEDURE LOAD_SKINIDUSER: LINE/COL ERROR -------- ----------------------------------------------------------------- 15/10 PL/SQL: SQL Statement ignored 23/84 PL/SQL: ORA-00904: "VALIDATE_PSWD_ISNOTNULL": invalid identifier 47/14 PL/SQL: Statement ignored 47/30 PLS-00364: loop index variable 'I' use is invalid 53/13 PL/SQL: SQL Statement ignored 53/77 PL/SQL: ORA-00904: "I"."SRC_ID": invalid identifier 53/77 PLS-00364: loop index variable 'I' use is invalid 60/13 PL/SQL: SQL Statement ignored 60/81 PL/SQL: ORA-00904: "I"."CHNL_ID": invalid identifier 60/81 PLS-00364: loop index variable 'I' use is invalid 67/13 PL/SQL: SQL Statement ignored 67/82 PL/SQL: ORA-00904: "I"."USER_ID": invalid identifier 67/82 PLS-00364: loop index variable 'I' use is invalid 72/12 PL/SQL: Statement ignored 73/22 PLS-00364: loop index variable 'I' use is invalid 79/10 PL/SQL: SQL Statement ignored 87/84 PL/SQL: ORA-00904: "VALIDATE_PSWD_ISNOTNULL": invalid identifier 109/14 PL/SQL: Statement ignored 109/30 PLS-00364: loop index variable 'I' use is invalid 115/77 PLS-00364: loop index variable 'I' use is invalid SQL> select sysdate from dual; SYSDATE -------------------------- 28-OCT-2010 11:09:57 SQL> spool off