SKINIDC@SKINPROD1> show user USER is "SKINIDC" SKINIDC@SKINPROD1> sta skinidca_oracle.sql PL/SQL procedure successfully completed. ALTERING TABLE SKINID_USERS ........... Table altered. CREATING TABLE SKINID_COUPON_CODE........... Table created. CREATING TABLE SKINID_PROMO_CODE ........... Table created. CREATING TABLE SKINID_SC_USER_MAP .......... Table created. CREATING TABLE SKINID_REFERFRIEND .......... Table created. CREATING TABLE SKINID_POINTS_LOG ......... Table created. CREATING TABLE SKINID_REDEEM_LOG ......... Table created. CREATING TABLE SKINID_EVENT_QUEUE ....... Table created. Table altered. Table altered. CREATING TABLE SKINID_SEND_LOG ....... Table created. Table altered. ALTERING TABLE SKINID_CRM_FIELDS ..... Table altered. UPDATING TABLE SKINID_CRM_FIELDS ..... PL/SQL procedure successfully completed. UPDATING TABLE SKINID_SITES ..... PL/SQL procedure successfully completed. CREATING SEQUENCE SKINID_COUPON_SEQ ........ Sequence created. CREATING SEQUENCE SKINID_PROMO_SEQ ......... Sequence created. CREATING SEQUENCE REFERFRIEND_ID_SEQ ....... Sequence created. CREATING SEQUENCE SKINID_DISCOUNTOFFER_SEQ ........ Sequence created. CREATING SEQUENCE SKINID_POINTS_LOG_SEQ ........ Sequence created. CREATING SEQUENCE REEDEMPOINTS_ID_SEQ ........ Sequence created. CREATING SEQUENCE SKINID_SC_USER_MAP_SEQ ........ Sequence created. CREATING SEQUENCE SKINID_EVENT_QUEUE_SQ ........ Sequence created. CREATING SEQUENCE SKINID_LOG_SQ ...... Sequence created. SKINIDC@SKINPROD1> sta SP_UPDATE_ROTATED.sql Procedure created. No errors. Procedure created. SKINIDC@SKINPROD1> sta EXEC_ROTATED.sql BEGIN SP_UPDATE_ROTATED; END; * ERROR at line 1: ORA-01403: no data found ORA-06512: at "SKINIDC.SP_UPDATE_ROTATED", line 19 ORA-06512: at line 1 Procedure created. Procedure dropped. SKINIDC@SKINPROD1> sta skinidca_oracle.sql PL/SQL procedure successfully completed. ALTERING TABLE SKINID_USERS ........... Table altered. CREATING TABLE SKINID_COUPON_CODE........... Table created. CREATING TABLE SKINID_PROMO_CODE ........... Table created. CREATING TABLE SKINID_SC_USER_MAP .......... Table created. CREATING TABLE SKINID_REFERFRIEND .......... Table created. CREATING TABLE SKINID_POINTS_LOG ......... Table created. CREATING TABLE SKINID_REDEEM_LOG ......... Table created. CREATING TABLE SKINID_EVENT_QUEUE ....... Table created. Table altered. Table altered. CREATING TABLE SKINID_SEND_LOG ....... Table created. Table altered. ALTERING TABLE SKINID_CRM_FIELDS ..... Table altered. UPDATING TABLE SKINID_CRM_FIELDS ..... PL/SQL procedure successfully completed. UPDATING TABLE SKINID_SITES ..... PL/SQL procedure successfully completed. CREATING SEQUENCE SKINID_COUPON_SEQ ........ Sequence created. CREATING SEQUENCE SKINID_PROMO_SEQ ......... Sequence created. CREATING SEQUENCE REFERFRIEND_ID_SEQ ....... Sequence created. CREATING SEQUENCE SKINID_DISCOUNTOFFER_SEQ ........ Sequence created. CREATING SEQUENCE SKINID_POINTS_LOG_SEQ ........ Sequence created. CREATING SEQUENCE REEDEMPOINTS_ID_SEQ ........ Sequence created. CREATING SEQUENCE SKINID_SC_USER_MAP_SEQ ........ Sequence created. CREATING SEQUENCE SKINID_EVENT_QUEUE_SQ ........ Sequence created. CREATING SEQUENCE SKINID_LOG_SQ ...... Sequence created. SKINIDC@SKINPROD1> sta CA_INDEX.sql Index created. Index created. Index created. Index created. Index created. Index created. Index created. Index created. Index created. Index created. Index created. Index created. Index created. SKINIDC@SKINPROD1> sta quartz_tables_oracle.sql 0 rows deleted. 0 rows deleted. 0 rows deleted. 0 rows deleted. 4 rows deleted. 0 rows deleted. 4 rows deleted. 4 rows deleted. 0 rows deleted. 0 rows deleted. 5 rows deleted. 1 row deleted. Table dropped. Table dropped. Table dropped. Table dropped. Table dropped. Table dropped. Table dropped. Table dropped. Table dropped. Table dropped. Table dropped. Table dropped. Table created. Table created. Table created. Table created. Table created. Table created. Table created. Table created. Table created. Table created. Table created. Table created. 1 row created. 1 row created. 1 row created. 1 row created. 1 row created. Index created. Index created. Index created. Index created. Index created. Index created. Index created. Index created. Index created. Index created. Index created. Index created. Index created. Index created. Commit complete. SKINIDC@SKINPROD1> spool off