SYS@UNTHSC> sta Prov_SysGrants.sql Enter Schema requiring grants : PROD Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. create synonym PROD.dbms_lock_allocated for sys.dbms_lock_allocated * ERROR at line 1: ORA-00955: name is already used by an existing object SYS@UNTHSC> sta Prov_SysGrants.sql Enter Schema requiring grants : PROD Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. create synonym PROD.dbms_lock_allocated for sys.dbms_lock_allocated * ERROR at line 1: ORA-00955: name is already used by an existing object SYS@UNTHSC> sta Prov_SysGrants.sql Enter Schema requiring grants : PRODARCH Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. create synonym PRODARCH.dbms_lock_allocated for sys.dbms_lock_allocated * ERROR at line 1: ORA-00955: name is already used by an existing object SYS@UNTHSC> sta Prov_SysGrants.sql Enter Schema requiring grants : PRODCOPY Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. create synonym PRODCOPY.dbms_lock_allocated for sys.dbms_lock_allocated * ERROR at line 1: ORA-00955: name is already used by an existing object SYS@UNTHSC> sta Prov_SysGrants.sql Enter Schema requiring grants : TRAIN Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. create synonym TRAIN.dbms_lock_allocated for sys.dbms_lock_allocated * ERROR at line 1: ORA-00955: name is already used by an existing object SYS@UNTHSC> sta Prov_SysGrants.sql Enter Schema requiring grants : TRAINARCH Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. create synonym TRAINARCH.dbms_lock_allocated for sys.dbms_lock_allocated * ERROR at line 1: ORA-00955: name is already used by an existing object SYS@UNTHSC> sta Prov_SysGrants.sql Enter Schema requiring grants : TRAINCOPY Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. create synonym TRAINCOPY.dbms_lock_allocated for sys.dbms_lock_allocated * ERROR at line 1: ORA-00955: name is already used by an existing object SYS@UNTHSC> conn PROD Connected. PROD@UNTHSC> sta Prov_AddTypes.sql SP2-0310: unable to open file "pk_drop.pck" No errors. pk_drop.drop_if_there('typ_scheduled_sub_acts_table','type',null); * ERROR at line 3: ORA-06550: line 3, column 4: PLS-00201: identifier 'PK_DROP.DROP_IF_THERE' must be declared ORA-06550: line 3, column 4: PL/SQL: Statement ignored ORA-06550: line 4, column 4: PLS-00201: identifier 'PK_DROP.DROP_IF_THERE' must be declared ORA-06550: line 4, column 4: PL/SQL: Statement ignored ORA-06550: line 5, column 4: PLS-00201: identifier 'PK_DROP.DROP_IF_THERE' must be declared ORA-06550: line 5, column 4: PL/SQL: Statement ignored ORA-06550: line 6, column 4: PLS-00201: identifier 'PK_DROP.DROP_IF_THERE' must be declared ORA-06550: line 6, column 4: PL/SQL: Statement ignored ORA-06550: line 7, column 4: PLS-00201: identifier 'PK_DROP.DROP_IF_THERE' must be declared ORA-06550: line 7, column 4: PL/SQL: Statement ignored ORA-06550: line 8, column 4: PLS-00201: identifier 'PK_DROP.DROP_IF_THERE' must be declared ORA-06550: line 8, column 4: PL/SQL: Statement ignored ORA-06550: line 9, column 4: PLS-00201: identifier 'PK_DROP.DROP_IF_THERE' must be declared ORA-06550: line 9, column 4: PL/SQL: Statement ig PROD@UNTHSC> PROD@UNTHSC> PROD@UNTHSC> CREATE OR REPLACE TYPE typ_number_table AS TABLE OF NUMBER 2 / Type created. PROD@UNTHSC> CREATE OR REPLACE TYPE typ_varchar2_table AS TABLE OF VARCHAR2(4000) 2 / Type created. PROD@UNTHSC> PROD@UNTHSC> CREATE OR REPLACE TYPE typ_cpws_result_object AS OBJECT ( 2 id NUMBER(20), 3 rec_user VARCHAR2(5), 4 rec_date DATE, 5 sample_id NUMBER(20), 6 meas_cd NUMBER(20), 7 range_id NUMBER(20), 8 units_cd NUMBER(20)) 9 / CREATE OR REPLACE TYPE typ_cpws_result_object AS OBJECT ( * ERROR at line 1: ORA-02303: cannot drop or replace a type with type or table dependents PROD@UNTHSC> CREATE OR REPLACE TYPE typ_cpws_sample_object AS OBJECT ( 2 id NUMBER(20), 3 rec_user VARCHAR2(5), 4 rec_date DATE, 5 ws_id NUMBER(20), 6 uar NUMBER(20), 7 lab_no VARCHAR2(17), 8 host_sid VARCHAR2(31), 9 sample_comm_seq_no NUMBER(20), 10 status NUMBER(20), 11 display_order NUMBER(20), 12 sample_volume NUMBER(1), 13 received_date DATE, 14 export_flag NUMBER(10), 15 dup_no NUMBER(9)) 16 / CREATE OR REPLACE TYPE typ_cpws_sample_object AS OBJECT ( * ERROR at line 1: ORA-02303: cannot drop or replace a type with type or table dependents PROD@UNTHSC> CREATE OR REPLACE TYPE typ_cpws_sample_table AS TABLE OF typ_cpws_sample_object 2 / Type created. PROD@UNTHSC> CREATE OR REPLACE TYPE typ_cpws_result_table AS TABLE OF typ_cpws_result_object 2 / Type created. PROD@UNTHSC> CREATE OR REPLACE TYPE fw_cons_details AS OBJECT ( 2 StartPeriod DATE, 3 EndPeriod DATE, 4 LiveAnmlDays NUMBER, 5 Raw_TotalConsumption NUMBER, 6 Raw_MeanConsumption NUMBER, 7 Formatted_TotalConsumption VARCHAR2(20), 8 Formatted_MeanConsumption VARCHAR2(20), 9 ExclusionStatus NUMBER) 10 / Type created. PROD@UNTHSC> PROD@UNTHSC> CREATE OR REPLACE TYPE fw_cons_details 2 AS OBJECT ( 3 StartPeriod DATE, 4 EndPeriod DATE, 5 LiveAnmlDays NUMBER, 6 Raw_TotalConsumption NUMBER, 7 Raw_MeanConsumption NUMBER, 8 Formatted_TotalConsumption VARCHAR2(20), 9 Formatted_MeanConsumption VARCHAR2(20), 10 ExclusionStatus NUMBER, 11 ErrorCode NUMBER, 12 Mean_NoOfDecimals NUMBER, 13 Total_NoOfDecimals NUMBER) 14 / Type created. PROD@UNTHSC> CREATE OR REPLACE TYPE typ_scheduled_sub_acts_object AS OBJECT ( 2 display_seq_num NUMBER(9), 3 subject_uar NUMBER(9), 4 act_id NUMBER(9)) 5 / CREATE OR REPLACE TYPE typ_scheduled_sub_acts_object AS OBJECT ( * ERROR at line 1: ORA-02303: cannot drop or replace a type with type or table dependents PROD@UNTHSC> CREATE OR REPLACE TYPE typ_scheduled_sub_acts_table AS TABLE OF typ_scheduled_sub_acts_object 2 / Type created. PROD@UNTHSC> PROD@UNTHSC> CREATE OR REPLACE TYPE pup_act_typ AS OBJECT ( 2 pup_uar NUMBER, 3 act_id NUMBER, 4 days_due NUMBER) 5 / CREATE OR REPLACE TYPE pup_act_typ AS OBJECT ( * ERROR at line 1: ORA-02303: cannot drop or replace a type with type or table dependents PROD@UNTHSC> PROD@UNTHSC> CREATE OR REPLACE TYPE pup_act_table AS TABLE OF pup_act_typ 2 / Type created. PROD@UNTHSC> PROD@UNTHSC> CREATE OR REPLACE TYPE food_water_record_type AS OBJECT ( 2 uar NUMBER(9), 3 sex NUMBER(1), 4 period_from NUMBER(9), 5 period_to NUMBER(9), 6 report_as VARCHAR2(20), 7 raw_total_consumption BINARY_DOUBLE, 8 formatted_total_consumption VARCHAR2(20), 9 raw_mean_consumption BINARY_DOUBLE, 10 formatted_mean_consumption VARCHAR2(20), 11 exclusion_status NUMBER(1)) 12 / CREATE OR REPLACE TYPE food_water_record_type AS OBJECT ( * ERROR at line 1: ORA-02303: cannot drop or replace a type with type or table dependents PROD@UNTHSC> PROD@UNTHSC> CREATE OR REPLACE TYPE food_water_table_type AS TABLE OF food_water_record_type; 2 / Type created. PROD@UNTHSC> DROP PACKAGE pk_drop 2 / DROP PACKAGE pk_drop * ERROR at line 1: ORA-04043: object PK_DROP does not exist PROD@UNTHSC> set echo off PROD@UNTHSC> conn PRODARCH Connected. PRODARCH@UNTHSC> sta Prov_AddTypes.sql SP2-0310: unable to open file "pk_drop.pck" No errors. pk_drop.drop_if_there('typ_scheduled_sub_acts_table','type',null); * ERROR at line 3: ORA-06550: line 3, column 4: PLS-00201: identifier 'PK_DROP.DROP_IF_THERE' must be declared ORA-06550: line 3, column 4: PL/SQL: Statement ignored ORA-06550: line 4, column 4: PLS-00201: identifier 'PK_DROP.DROP_IF_THERE' must be declared ORA-06550: line 4, column 4: PL/SQL: Statement ignored ORA-06550: line 5, column 4: PLS-00201: identifier 'PK_DROP.DROP_IF_THERE' must be declared ORA-06550: line 5, column 4: PL/SQL: Statement ignored ORA-06550: line 6, column 4: PLS-00201: identifier 'PK_DROP.DROP_IF_THERE' must be declared ORA-06550: line 6, column 4: PL/SQL: Statement ignored ORA-06550: line 7, column 4: PLS-00201: identifier 'PK_DROP.DROP_IF_THERE' must be declared ORA-06550: line 7, column 4: PL/SQL: Statement ignored ORA-06550: line 8, column 4: PLS-00201: identifier 'PK_DROP.DROP_IF_THERE' must be declared ORA-06550: line 8, column 4: PL/SQL: Statement ignored ORA-06550: line 9, column 4: PLS-00201: identifier 'PK_DROP.DROP_IF_THERE' must be declared ORA-06550: line 9, column 4: PL/SQL: Statement ig PRODARCH@UNTHSC> PRODARCH@UNTHSC> PRODARCH@UNTHSC> CREATE OR REPLACE TYPE typ_number_table AS TABLE OF NUMBER 2 / Type created. PRODARCH@UNTHSC> CREATE OR REPLACE TYPE typ_varchar2_table AS TABLE OF VARCHAR2(4000) 2 / Type created. PRODARCH@UNTHSC> PRODARCH@UNTHSC> CREATE OR REPLACE TYPE typ_cpws_result_object AS OBJECT ( 2 id NUMBER(20), 3 rec_user VARCHAR2(5), 4 rec_date DATE, 5 sample_id NUMBER(20), 6 meas_cd NUMBER(20), 7 range_id NUMBER(20), 8 units_cd NUMBER(20)) 9 / CREATE OR REPLACE TYPE typ_cpws_result_object AS OBJECT ( * ERROR at line 1: ORA-02303: cannot drop or replace a type with type or table dependents PRODARCH@UNTHSC> CREATE OR REPLACE TYPE typ_cpws_sample_object AS OBJECT ( 2 id NUMBER(20), 3 rec_user VARCHAR2(5), 4 rec_date DATE, 5 ws_id NUMBER(20), 6 uar NUMBER(20), 7 lab_no VARCHAR2(17), 8 host_sid VARCHAR2(31), 9 sample_comm_seq_no NUMBER(20), 10 status NUMBER(20), 11 display_order NUMBER(20), 12 sample_volume NUMBER(1), 13 received_date DATE, 14 export_flag NUMBER(10), 15 dup_no NUMBER(9)) 16 / CREATE OR REPLACE TYPE typ_cpws_sample_object AS OBJECT ( * ERROR at line 1: ORA-02303: cannot drop or replace a type with type or table dependents PRODARCH@UNTHSC> CREATE OR REPLACE TYPE typ_cpws_sample_table AS TABLE OF typ_cpws_sample_object 2 / Type created. PRODARCH@UNTHSC> CREATE OR REPLACE TYPE typ_cpws_result_table AS TABLE OF typ_cpws_result_object 2 / Type created. PRODARCH@UNTHSC> CREATE OR REPLACE TYPE fw_cons_details AS OBJECT ( 2 StartPeriod DATE, 3 EndPeriod DATE, 4 LiveAnmlDays NUMBER, 5 Raw_TotalConsumption NUMBER, 6 Raw_MeanConsumption NUMBER, 7 Formatted_TotalConsumption VARCHAR2(20), 8 Formatted_MeanConsumption VARCHAR2(20), 9 ExclusionStatus NUMBER) 10 / Type created. PRODARCH@UNTHSC> PRODARCH@UNTHSC> CREATE OR REPLACE TYPE fw_cons_details 2 AS OBJECT ( 3 StartPeriod DATE, 4 EndPeriod DATE, 5 LiveAnmlDays NUMBER, 6 Raw_TotalConsumption NUMBER, 7 Raw_MeanConsumption NUMBER, 8 Formatted_TotalConsumption VARCHAR2(20), 9 Formatted_MeanConsumption VARCHAR2(20), 10 ExclusionStatus NUMBER, 11 ErrorCode NUMBER, 12 Mean_NoOfDecimals NUMBER, 13 Total_NoOfDecimals NUMBER) 14 / Type created. PRODARCH@UNTHSC> CREATE OR REPLACE TYPE typ_scheduled_sub_acts_object AS OBJECT ( 2 display_seq_num NUMBER(9), 3 subject_uar NUMBER(9), 4 act_id NUMBER(9)) 5 / CREATE OR REPLACE TYPE typ_scheduled_sub_acts_object AS OBJECT ( * ERROR at line 1: ORA-02303: cannot drop or replace a type with type or table dependents PRODARCH@UNTHSC> CREATE OR REPLACE TYPE typ_scheduled_sub_acts_table AS TABLE OF typ_scheduled_sub_acts_object 2 / Type created. PRODARCH@UNTHSC> PRODARCH@UNTHSC> CREATE OR REPLACE TYPE pup_act_typ AS OBJECT ( 2 pup_uar NUMBER, 3 act_id NUMBER, 4 days_due NUMBER) 5 / CREATE OR REPLACE TYPE pup_act_typ AS OBJECT ( * ERROR at line 1: ORA-02303: cannot drop or replace a type with type or table dependents PRODARCH@UNTHSC> PRODARCH@UNTHSC> CREATE OR REPLACE TYPE pup_act_table AS TABLE OF pup_act_typ 2 / Type created. PRODARCH@UNTHSC> PRODARCH@UNTHSC> CREATE OR REPLACE TYPE food_water_record_type AS OBJECT ( 2 uar NUMBER(9), 3 sex NUMBER(1), 4 period_from NUMBER(9), 5 period_to NUMBER(9), 6 report_as VARCHAR2(20), 7 raw_total_consumption BINARY_DOUBLE, 8 formatted_total_consumption VARCHAR2(20), 9 raw_mean_consumption BINARY_DOUBLE, 10 formatted_mean_consumption VARCHAR2(20), 11 exclusion_status NUMBER(1)) 12 / CREATE OR REPLACE TYPE food_water_record_type AS OBJECT ( * ERROR at line 1: ORA-02303: cannot drop or replace a type with type or table dependents PRODARCH@UNTHSC> PRODARCH@UNTHSC> CREATE OR REPLACE TYPE food_water_table_type AS TABLE OF food_water_record_type; 2 / Type created. PRODARCH@UNTHSC> DROP PACKAGE pk_drop 2 / DROP PACKAGE pk_drop * ERROR at line 1: ORA-04043: object PK_DROP does not exist PRODARCH@UNTHSC> set echo off PRODARCH@UNTHSC> conn PRODCOPY Connected. PRODCOPY@UNTHSC> sta Prov_AddTypes.sql SP2-0310: unable to open file "pk_drop.pck" No errors. pk_drop.drop_if_there('typ_scheduled_sub_acts_table','type',null); * ERROR at line 3: ORA-06550: line 3, column 4: PLS-00201: identifier 'PK_DROP.DROP_IF_THERE' must be declared ORA-06550: line 3, column 4: PL/SQL: Statement ignored ORA-06550: line 4, column 4: PLS-00201: identifier 'PK_DROP.DROP_IF_THERE' must be declared ORA-06550: line 4, column 4: PL/SQL: Statement ignored ORA-06550: line 5, column 4: PLS-00201: identifier 'PK_DROP.DROP_IF_THERE' must be declared ORA-06550: line 5, column 4: PL/SQL: Statement ignored ORA-06550: line 6, column 4: PLS-00201: identifier 'PK_DROP.DROP_IF_THERE' must be declared ORA-06550: line 6, column 4: PL/SQL: Statement ignored ORA-06550: line 7, column 4: PLS-00201: identifier 'PK_DROP.DROP_IF_THERE' must be declared ORA-06550: line 7, column 4: PL/SQL: Statement ignored ORA-06550: line 8, column 4: PLS-00201: identifier 'PK_DROP.DROP_IF_THERE' must be declared ORA-06550: line 8, column 4: PL/SQL: Statement ignored ORA-06550: line 9, column 4: PLS-00201: identifier 'PK_DROP.DROP_IF_THERE' must be declared ORA-06550: line 9, column 4: PL/SQL: Statement ig PRODCOPY@UNTHSC> PRODCOPY@UNTHSC> PRODCOPY@UNTHSC> CREATE OR REPLACE TYPE typ_number_table AS TABLE OF NUMBER 2 / Type created. PRODCOPY@UNTHSC> CREATE OR REPLACE TYPE typ_varchar2_table AS TABLE OF VARCHAR2(4000) 2 / Type created. PRODCOPY@UNTHSC> PRODCOPY@UNTHSC> CREATE OR REPLACE TYPE typ_cpws_result_object AS OBJECT ( 2 id NUMBER(20), 3 rec_user VARCHAR2(5), 4 rec_date DATE, 5 sample_id NUMBER(20), 6 meas_cd NUMBER(20), 7 range_id NUMBER(20), 8 units_cd NUMBER(20)) 9 / CREATE OR REPLACE TYPE typ_cpws_result_object AS OBJECT ( * ERROR at line 1: ORA-02303: cannot drop or replace a type with type or table dependents PRODCOPY@UNTHSC> CREATE OR REPLACE TYPE typ_cpws_sample_object AS OBJECT ( 2 id NUMBER(20), 3 rec_user VARCHAR2(5), 4 rec_date DATE, 5 ws_id NUMBER(20), 6 uar NUMBER(20), 7 lab_no VARCHAR2(17), 8 host_sid VARCHAR2(31), 9 sample_comm_seq_no NUMBER(20), 10 status NUMBER(20), 11 display_order NUMBER(20), 12 sample_volume NUMBER(1), 13 received_date DATE, 14 export_flag NUMBER(10), 15 dup_no NUMBER(9)) 16 / CREATE OR REPLACE TYPE typ_cpws_sample_object AS OBJECT ( * ERROR at line 1: ORA-02303: cannot drop or replace a type with type or table dependents PRODCOPY@UNTHSC> CREATE OR REPLACE TYPE typ_cpws_sample_table AS TABLE OF typ_cpws_sample_object 2 / Type created. PRODCOPY@UNTHSC> CREATE OR REPLACE TYPE typ_cpws_result_table AS TABLE OF typ_cpws_result_object 2 / Type created. PRODCOPY@UNTHSC> CREATE OR REPLACE TYPE fw_cons_details AS OBJECT ( 2 StartPeriod DATE, 3 EndPeriod DATE, 4 LiveAnmlDays NUMBER, 5 Raw_TotalConsumption NUMBER, 6 Raw_MeanConsumption NUMBER, 7 Formatted_TotalConsumption VARCHAR2(20), 8 Formatted_MeanConsumption VARCHAR2(20), 9 ExclusionStatus NUMBER) 10 / Type created. PRODCOPY@UNTHSC> PRODCOPY@UNTHSC> CREATE OR REPLACE TYPE fw_cons_details 2 AS OBJECT ( 3 StartPeriod DATE, 4 EndPeriod DATE, 5 LiveAnmlDays NUMBER, 6 Raw_TotalConsumption NUMBER, 7 Raw_MeanConsumption NUMBER, 8 Formatted_TotalConsumption VARCHAR2(20), 9 Formatted_MeanConsumption VARCHAR2(20), 10 ExclusionStatus NUMBER, 11 ErrorCode NUMBER, 12 Mean_NoOfDecimals NUMBER, 13 Total_NoOfDecimals NUMBER) 14 / Type created. PRODCOPY@UNTHSC> CREATE OR REPLACE TYPE typ_scheduled_sub_acts_object AS OBJECT ( 2 display_seq_num NUMBER(9), 3 subject_uar NUMBER(9), 4 act_id NUMBER(9)) 5 / CREATE OR REPLACE TYPE typ_scheduled_sub_acts_object AS OBJECT ( * ERROR at line 1: ORA-02303: cannot drop or replace a type with type or table dependents PRODCOPY@UNTHSC> CREATE OR REPLACE TYPE typ_scheduled_sub_acts_table AS TABLE OF typ_scheduled_sub_acts_object 2 / Type created. PRODCOPY@UNTHSC> PRODCOPY@UNTHSC> CREATE OR REPLACE TYPE pup_act_typ AS OBJECT ( 2 pup_uar NUMBER, 3 act_id NUMBER, 4 days_due NUMBER) 5 / CREATE OR REPLACE TYPE pup_act_typ AS OBJECT ( * ERROR at line 1: ORA-02303: cannot drop or replace a type with type or table dependents PRODCOPY@UNTHSC> PRODCOPY@UNTHSC> CREATE OR REPLACE TYPE pup_act_table AS TABLE OF pup_act_typ 2 / Type created. PRODCOPY@UNTHSC> PRODCOPY@UNTHSC> CREATE OR REPLACE TYPE food_water_record_type AS OBJECT ( 2 uar NUMBER(9), 3 sex NUMBER(1), 4 period_from NUMBER(9), 5 period_to NUMBER(9), 6 report_as VARCHAR2(20), 7 raw_total_consumption BINARY_DOUBLE, 8 formatted_total_consumption VARCHAR2(20), 9 raw_mean_consumption BINARY_DOUBLE, 10 formatted_mean_consumption VARCHAR2(20), 11 exclusion_status NUMBER(1)) 12 / CREATE OR REPLACE TYPE food_water_record_type AS OBJECT ( * ERROR at line 1: ORA-02303: cannot drop or replace a type with type or table dependents PRODCOPY@UNTHSC> PRODCOPY@UNTHSC> CREATE OR REPLACE TYPE food_water_table_type AS TABLE OF food_water_record_type; 2 / Type created. PRODCOPY@UNTHSC> DROP PACKAGE pk_drop 2 / DROP PACKAGE pk_drop * ERROR at line 1: ORA-04043: object PK_DROP does not exist PRODCOPY@UNTHSC> set echo off PRODCOPY@UNTHSC> conn TRAIN Connected. TRAIN@UNTHSC> sta Prov_AddTypes.sql SP2-0310: unable to open file "pk_drop.pck" No errors. pk_drop.drop_if_there('typ_scheduled_sub_acts_table','type',null); * ERROR at line 3: ORA-06550: line 3, column 4: PLS-00201: identifier 'PK_DROP.DROP_IF_THERE' must be declared ORA-06550: line 3, column 4: PL/SQL: Statement ignored ORA-06550: line 4, column 4: PLS-00201: identifier 'PK_DROP.DROP_IF_THERE' must be declared ORA-06550: line 4, column 4: PL/SQL: Statement ignored ORA-06550: line 5, column 4: PLS-00201: identifier 'PK_DROP.DROP_IF_THERE' must be declared ORA-06550: line 5, column 4: PL/SQL: Statement ignored ORA-06550: line 6, column 4: PLS-00201: identifier 'PK_DROP.DROP_IF_THERE' must be declared ORA-06550: line 6, column 4: PL/SQL: Statement ignored ORA-06550: line 7, column 4: PLS-00201: identifier 'PK_DROP.DROP_IF_THERE' must be declared ORA-06550: line 7, column 4: PL/SQL: Statement ignored ORA-06550: line 8, column 4: PLS-00201: identifier 'PK_DROP.DROP_IF_THERE' must be declared ORA-06550: line 8, column 4: PL/SQL: Statement ignored ORA-06550: line 9, column 4: PLS-00201: identifier 'PK_DROP.DROP_IF_THERE' must be declared ORA-06550: line 9, column 4: PL/SQL: Statement ig TRAIN@UNTHSC> TRAIN@UNTHSC> TRAIN@UNTHSC> CREATE OR REPLACE TYPE typ_number_table AS TABLE OF NUMBER 2 / Type created. TRAIN@UNTHSC> CREATE OR REPLACE TYPE typ_varchar2_table AS TABLE OF VARCHAR2(4000) 2 / Type created. TRAIN@UNTHSC> TRAIN@UNTHSC> CREATE OR REPLACE TYPE typ_cpws_result_object AS OBJECT ( 2 id NUMBER(20), 3 rec_user VARCHAR2(5), 4 rec_date DATE, 5 sample_id NUMBER(20), 6 meas_cd NUMBER(20), 7 range_id NUMBER(20), 8 units_cd NUMBER(20)) 9 / CREATE OR REPLACE TYPE typ_cpws_result_object AS OBJECT ( * ERROR at line 1: ORA-02303: cannot drop or replace a type with type or table dependents TRAIN@UNTHSC> CREATE OR REPLACE TYPE typ_cpws_sample_object AS OBJECT ( 2 id NUMBER(20), 3 rec_user VARCHAR2(5), 4 rec_date DATE, 5 ws_id NUMBER(20), 6 uar NUMBER(20), 7 lab_no VARCHAR2(17), 8 host_sid VARCHAR2(31), 9 sample_comm_seq_no NUMBER(20), 10 status NUMBER(20), 11 display_order NUMBER(20), 12 sample_volume NUMBER(1), 13 received_date DATE, 14 export_flag NUMBER(10), 15 dup_no NUMBER(9)) 16 / CREATE OR REPLACE TYPE typ_cpws_sample_object AS OBJECT ( * ERROR at line 1: ORA-02303: cannot drop or replace a type with type or table dependents TRAIN@UNTHSC> CREATE OR REPLACE TYPE typ_cpws_sample_table AS TABLE OF typ_cpws_sample_object 2 / Type created. TRAIN@UNTHSC> CREATE OR REPLACE TYPE typ_cpws_result_table AS TABLE OF typ_cpws_result_object 2 / Type created. TRAIN@UNTHSC> CREATE OR REPLACE TYPE fw_cons_details AS OBJECT ( 2 StartPeriod DATE, 3 EndPeriod DATE, 4 LiveAnmlDays NUMBER, 5 Raw_TotalConsumption NUMBER, 6 Raw_MeanConsumption NUMBER, 7 Formatted_TotalConsumption VARCHAR2(20), 8 Formatted_MeanConsumption VARCHAR2(20), 9 ExclusionStatus NUMBER) 10 / Type created. TRAIN@UNTHSC> TRAIN@UNTHSC> CREATE OR REPLACE TYPE fw_cons_details 2 AS OBJECT ( 3 StartPeriod DATE, 4 EndPeriod DATE, 5 LiveAnmlDays NUMBER, 6 Raw_TotalConsumption NUMBER, 7 Raw_MeanConsumption NUMBER, 8 Formatted_TotalConsumption VARCHAR2(20), 9 Formatted_MeanConsumption VARCHAR2(20), 10 ExclusionStatus NUMBER, 11 ErrorCode NUMBER, 12 Mean_NoOfDecimals NUMBER, 13 Total_NoOfDecimals NUMBER) 14 / Type created. TRAIN@UNTHSC> CREATE OR REPLACE TYPE typ_scheduled_sub_acts_object AS OBJECT ( 2 display_seq_num NUMBER(9), 3 subject_uar NUMBER(9), 4 act_id NUMBER(9)) 5 / CREATE OR REPLACE TYPE typ_scheduled_sub_acts_object AS OBJECT ( * ERROR at line 1: ORA-02303: cannot drop or replace a type with type or table dependents TRAIN@UNTHSC> CREATE OR REPLACE TYPE typ_scheduled_sub_acts_table AS TABLE OF typ_scheduled_sub_acts_object 2 / Type created. TRAIN@UNTHSC> TRAIN@UNTHSC> CREATE OR REPLACE TYPE pup_act_typ AS OBJECT ( 2 pup_uar NUMBER, 3 act_id NUMBER, 4 days_due NUMBER) 5 / CREATE OR REPLACE TYPE pup_act_typ AS OBJECT ( * ERROR at line 1: ORA-02303: cannot drop or replace a type with type or table dependents TRAIN@UNTHSC> TRAIN@UNTHSC> CREATE OR REPLACE TYPE pup_act_table AS TABLE OF pup_act_typ 2 / Type created. TRAIN@UNTHSC> TRAIN@UNTHSC> CREATE OR REPLACE TYPE food_water_record_type AS OBJECT ( 2 uar NUMBER(9), 3 sex NUMBER(1), 4 period_from NUMBER(9), 5 period_to NUMBER(9), 6 report_as VARCHAR2(20), 7 raw_total_consumption BINARY_DOUBLE, 8 formatted_total_consumption VARCHAR2(20), 9 raw_mean_consumption BINARY_DOUBLE, 10 formatted_mean_consumption VARCHAR2(20), 11 exclusion_status NUMBER(1)) 12 / CREATE OR REPLACE TYPE food_water_record_type AS OBJECT ( * ERROR at line 1: ORA-02303: cannot drop or replace a type with type or table dependents TRAIN@UNTHSC> TRAIN@UNTHSC> CREATE OR REPLACE TYPE food_water_table_type AS TABLE OF food_water_record_type; 2 / Type created. TRAIN@UNTHSC> DROP PACKAGE pk_drop 2 / DROP PACKAGE pk_drop * ERROR at line 1: ORA-04043: object PK_DROP does not exist TRAIN@UNTHSC> set echo off TRAIN@UNTHSC> conn TRAINARCH Connected. TRAINARCH@UNTHSC> sta Prov_AddTypes.sql SP2-0310: unable to open file "pk_drop.pck" No errors. pk_drop.drop_if_there('typ_scheduled_sub_acts_table','type',null); * ERROR at line 3: ORA-06550: line 3, column 4: PLS-00201: identifier 'PK_DROP.DROP_IF_THERE' must be declared ORA-06550: line 3, column 4: PL/SQL: Statement ignored ORA-06550: line 4, column 4: PLS-00201: identifier 'PK_DROP.DROP_IF_THERE' must be declared ORA-06550: line 4, column 4: PL/SQL: Statement ignored ORA-06550: line 5, column 4: PLS-00201: identifier 'PK_DROP.DROP_IF_THERE' must be declared ORA-06550: line 5, column 4: PL/SQL: Statement ignored ORA-06550: line 6, column 4: PLS-00201: identifier 'PK_DROP.DROP_IF_THERE' must be declared ORA-06550: line 6, column 4: PL/SQL: Statement ignored ORA-06550: line 7, column 4: PLS-00201: identifier 'PK_DROP.DROP_IF_THERE' must be declared ORA-06550: line 7, column 4: PL/SQL: Statement ignored ORA-06550: line 8, column 4: PLS-00201: identifier 'PK_DROP.DROP_IF_THERE' must be declared ORA-06550: line 8, column 4: PL/SQL: Statement ignored ORA-06550: line 9, column 4: PLS-00201: identifier 'PK_DROP.DROP_IF_THERE' must be declared ORA-06550: line 9, column 4: PL/SQL: Statement ig TRAINARCH@UNTHSC> TRAINARCH@UNTHSC> TRAINARCH@UNTHSC> CREATE OR REPLACE TYPE typ_number_table AS TABLE OF NUMBER 2 / Type created. TRAINARCH@UNTHSC> CREATE OR REPLACE TYPE typ_varchar2_table AS TABLE OF VARCHAR2(4000) 2 / Type created. TRAINARCH@UNTHSC> TRAINARCH@UNTHSC> CREATE OR REPLACE TYPE typ_cpws_result_object AS OBJECT ( 2 id NUMBER(20), 3 rec_user VARCHAR2(5), 4 rec_date DATE, 5 sample_id NUMBER(20), 6 meas_cd NUMBER(20), 7 range_id NUMBER(20), 8 units_cd NUMBER(20)) 9 / CREATE OR REPLACE TYPE typ_cpws_result_object AS OBJECT ( * ERROR at line 1: ORA-02303: cannot drop or replace a type with type or table dependents TRAINARCH@UNTHSC> CREATE OR REPLACE TYPE typ_cpws_sample_object AS OBJECT ( 2 id NUMBER(20), 3 rec_user VARCHAR2(5), 4 rec_date DATE, 5 ws_id NUMBER(20), 6 uar NUMBER(20), 7 lab_no VARCHAR2(17), 8 host_sid VARCHAR2(31), 9 sample_comm_seq_no NUMBER(20), 10 status NUMBER(20), 11 display_order NUMBER(20), 12 sample_volume NUMBER(1), 13 received_date DATE, 14 export_flag NUMBER(10), 15 dup_no NUMBER(9)) 16 / CREATE OR REPLACE TYPE typ_cpws_sample_object AS OBJECT ( * ERROR at line 1: ORA-02303: cannot drop or replace a type with type or table dependents TRAINARCH@UNTHSC> CREATE OR REPLACE TYPE typ_cpws_sample_table AS TABLE OF typ_cpws_sample_object 2 / Type created. TRAINARCH@UNTHSC> CREATE OR REPLACE TYPE typ_cpws_result_table AS TABLE OF typ_cpws_result_object 2 / Type created. TRAINARCH@UNTHSC> CREATE OR REPLACE TYPE fw_cons_details AS OBJECT ( 2 StartPeriod DATE, 3 EndPeriod DATE, 4 LiveAnmlDays NUMBER, 5 Raw_TotalConsumption NUMBER, 6 Raw_MeanConsumption NUMBER, 7 Formatted_TotalConsumption VARCHAR2(20), 8 Formatted_MeanConsumption VARCHAR2(20), 9 ExclusionStatus NUMBER) 10 / Type created. TRAINARCH@UNTHSC> TRAINARCH@UNTHSC> CREATE OR REPLACE TYPE fw_cons_details 2 AS OBJECT ( 3 StartPeriod DATE, 4 EndPeriod DATE, 5 LiveAnmlDays NUMBER, 6 Raw_TotalConsumption NUMBER, 7 Raw_MeanConsumption NUMBER, 8 Formatted_TotalConsumption VARCHAR2(20), 9 Formatted_MeanConsumption VARCHAR2(20), 10 ExclusionStatus NUMBER, 11 ErrorCode NUMBER, 12 Mean_NoOfDecimals NUMBER, 13 Total_NoOfDecimals NUMBER) 14 / Type created. TRAINARCH@UNTHSC> CREATE OR REPLACE TYPE typ_scheduled_sub_acts_object AS OBJECT ( 2 display_seq_num NUMBER(9), 3 subject_uar NUMBER(9), 4 act_id NUMBER(9)) 5 / CREATE OR REPLACE TYPE typ_scheduled_sub_acts_object AS OBJECT ( * ERROR at line 1: ORA-02303: cannot drop or replace a type with type or table dependents TRAINARCH@UNTHSC> CREATE OR REPLACE TYPE typ_scheduled_sub_acts_table AS TABLE OF typ_scheduled_sub_acts_object 2 / Type created. TRAINARCH@UNTHSC> TRAINARCH@UNTHSC> CREATE OR REPLACE TYPE pup_act_typ AS OBJECT ( 2 pup_uar NUMBER, 3 act_id NUMBER, 4 days_due NUMBER) 5 / CREATE OR REPLACE TYPE pup_act_typ AS OBJECT ( * ERROR at line 1: ORA-02303: cannot drop or replace a type with type or table dependents TRAINARCH@UNTHSC> TRAINARCH@UNTHSC> CREATE OR REPLACE TYPE pup_act_table AS TABLE OF pup_act_typ 2 / Type created. TRAINARCH@UNTHSC> TRAINARCH@UNTHSC> CREATE OR REPLACE TYPE food_water_record_type AS OBJECT ( 2 uar NUMBER(9), 3 sex NUMBER(1), 4 period_from NUMBER(9), 5 period_to NUMBER(9), 6 report_as VARCHAR2(20), 7 raw_total_consumption BINARY_DOUBLE, 8 formatted_total_consumption VARCHAR2(20), 9 raw_mean_consumption BINARY_DOUBLE, 10 formatted_mean_consumption VARCHAR2(20), 11 exclusion_status NUMBER(1)) 12 / CREATE OR REPLACE TYPE food_water_record_type AS OBJECT ( * ERROR at line 1: ORA-02303: cannot drop or replace a type with type or table dependents TRAINARCH@UNTHSC> TRAINARCH@UNTHSC> CREATE OR REPLACE TYPE food_water_table_type AS TABLE OF food_water_record_type; 2 / Type created. TRAINARCH@UNTHSC> DROP PACKAGE pk_drop 2 / DROP PACKAGE pk_drop * ERROR at line 1: ORA-04043: object PK_DROP does not exist TRAINARCH@UNTHSC> set echo off TRAINARCH@UNTHSC> conn TRAINCOPY Connected. TRAINCOPY@UNTHSC> sta Prov_AddTypes.sql SP2-0310: unable to open file "pk_drop.pck" No errors. pk_drop.drop_if_there('typ_scheduled_sub_acts_table','type',null); * ERROR at line 3: ORA-06550: line 3, column 4: PLS-00201: identifier 'PK_DROP.DROP_IF_THERE' must be declared ORA-06550: line 3, column 4: PL/SQL: Statement ignored ORA-06550: line 4, column 4: PLS-00201: identifier 'PK_DROP.DROP_IF_THERE' must be declared ORA-06550: line 4, column 4: PL/SQL: Statement ignored ORA-06550: line 5, column 4: PLS-00201: identifier 'PK_DROP.DROP_IF_THERE' must be declared ORA-06550: line 5, column 4: PL/SQL: Statement ignored ORA-06550: line 6, column 4: PLS-00201: identifier 'PK_DROP.DROP_IF_THERE' must be declared ORA-06550: line 6, column 4: PL/SQL: Statement ignored ORA-06550: line 7, column 4: PLS-00201: identifier 'PK_DROP.DROP_IF_THERE' must be declared ORA-06550: line 7, column 4: PL/SQL: Statement ignored ORA-06550: line 8, column 4: PLS-00201: identifier 'PK_DROP.DROP_IF_THERE' must be declared ORA-06550: line 8, column 4: PL/SQL: Statement ignored ORA-06550: line 9, column 4: PLS-00201: identifier 'PK_DROP.DROP_IF_THERE' must be declared ORA-06550: line 9, column 4: PL/SQL: Statement ig TRAINCOPY@UNTHSC> TRAINCOPY@UNTHSC> TRAINCOPY@UNTHSC> CREATE OR REPLACE TYPE typ_number_table AS TABLE OF NUMBER 2 / Type created. TRAINCOPY@UNTHSC> CREATE OR REPLACE TYPE typ_varchar2_table AS TABLE OF VARCHAR2(4000) 2 / Type created. TRAINCOPY@UNTHSC> TRAINCOPY@UNTHSC> CREATE OR REPLACE TYPE typ_cpws_result_object AS OBJECT ( 2 id NUMBER(20), 3 rec_user VARCHAR2(5), 4 rec_date DATE, 5 sample_id NUMBER(20), 6 meas_cd NUMBER(20), 7 range_id NUMBER(20), 8 units_cd NUMBER(20)) 9 / CREATE OR REPLACE TYPE typ_cpws_result_object AS OBJECT ( * ERROR at line 1: ORA-02303: cannot drop or replace a type with type or table dependents TRAINCOPY@UNTHSC> CREATE OR REPLACE TYPE typ_cpws_sample_object AS OBJECT ( 2 id NUMBER(20), 3 rec_user VARCHAR2(5), 4 rec_date DATE, 5 ws_id NUMBER(20), 6 uar NUMBER(20), 7 lab_no VARCHAR2(17), 8 host_sid VARCHAR2(31), 9 sample_comm_seq_no NUMBER(20), 10 status NUMBER(20), 11 display_order NUMBER(20), 12 sample_volume NUMBER(1), 13 received_date DATE, 14 export_flag NUMBER(10), 15 dup_no NUMBER(9)) 16 / CREATE OR REPLACE TYPE typ_cpws_sample_object AS OBJECT ( * ERROR at line 1: ORA-02303: cannot drop or replace a type with type or table dependents TRAINCOPY@UNTHSC> CREATE OR REPLACE TYPE typ_cpws_sample_table AS TABLE OF typ_cpws_sample_object 2 / Type created. TRAINCOPY@UNTHSC> CREATE OR REPLACE TYPE typ_cpws_result_table AS TABLE OF typ_cpws_result_object 2 / Type created. TRAINCOPY@UNTHSC> CREATE OR REPLACE TYPE fw_cons_details AS OBJECT ( 2 StartPeriod DATE, 3 EndPeriod DATE, 4 LiveAnmlDays NUMBER, 5 Raw_TotalConsumption NUMBER, 6 Raw_MeanConsumption NUMBER, 7 Formatted_TotalConsumption VARCHAR2(20), 8 Formatted_MeanConsumption VARCHAR2(20), 9 ExclusionStatus NUMBER) 10 / Type created. TRAINCOPY@UNTHSC> TRAINCOPY@UNTHSC> CREATE OR REPLACE TYPE fw_cons_details 2 AS OBJECT ( 3 StartPeriod DATE, 4 EndPeriod DATE, 5 LiveAnmlDays NUMBER, 6 Raw_TotalConsumption NUMBER, 7 Raw_MeanConsumption NUMBER, 8 Formatted_TotalConsumption VARCHAR2(20), 9 Formatted_MeanConsumption VARCHAR2(20), 10 ExclusionStatus NUMBER, 11 ErrorCode NUMBER, 12 Mean_NoOfDecimals NUMBER, 13 Total_NoOfDecimals NUMBER) 14 / Type created. TRAINCOPY@UNTHSC> CREATE OR REPLACE TYPE typ_scheduled_sub_acts_object AS OBJECT ( 2 display_seq_num NUMBER(9), 3 subject_uar NUMBER(9), 4 act_id NUMBER(9)) 5 / CREATE OR REPLACE TYPE typ_scheduled_sub_acts_object AS OBJECT ( * ERROR at line 1: ORA-02303: cannot drop or replace a type with type or table dependents TRAINCOPY@UNTHSC> CREATE OR REPLACE TYPE typ_scheduled_sub_acts_table AS TABLE OF typ_scheduled_sub_acts_object 2 / Type created. TRAINCOPY@UNTHSC> TRAINCOPY@UNTHSC> CREATE OR REPLACE TYPE pup_act_typ AS OBJECT ( 2 pup_uar NUMBER, 3 act_id NUMBER, 4 days_due NUMBER) 5 / CREATE OR REPLACE TYPE pup_act_typ AS OBJECT ( * ERROR at line 1: ORA-02303: cannot drop or replace a type with type or table dependents TRAINCOPY@UNTHSC> TRAINCOPY@UNTHSC> CREATE OR REPLACE TYPE pup_act_table AS TABLE OF pup_act_typ 2 / Type created. TRAINCOPY@UNTHSC> TRAINCOPY@UNTHSC> CREATE OR REPLACE TYPE food_water_record_type AS OBJECT ( 2 uar NUMBER(9), 3 sex NUMBER(1), 4 period_from NUMBER(9), 5 period_to NUMBER(9), 6 report_as VARCHAR2(20), 7 raw_total_consumption BINARY_DOUBLE, 8 formatted_total_consumption VARCHAR2(20), 9 raw_mean_consumption BINARY_DOUBLE, 10 formatted_mean_consumption VARCHAR2(20), 11 exclusion_status NUMBER(1)) 12 / CREATE OR REPLACE TYPE food_water_record_type AS OBJECT ( * ERROR at line 1: ORA-02303: cannot drop or replace a type with type or table dependents TRAINCOPY@UNTHSC> TRAINCOPY@UNTHSC> CREATE OR REPLACE TYPE food_water_table_type AS TABLE OF food_water_record_type; 2 / Type created. TRAINCOPY@UNTHSC> DROP PACKAGE pk_drop 2 / DROP PACKAGE pk_drop * ERROR at line 1: ORA-04043: object PK_DROP does not exist TRAINCOPY@UNTHSC> set echo off TRAINCOPY@UNTHSC> conn PROD Connected. PROD@UNTHSC> sta Prov_Compile.sql Wrote file Instem_SQLPlusEnv.sql Compiling invalid objects, please wait... Compilation complete. Still Invalid ------------- 0 PROD@UNTHSC> conn PRODARCH Connected. PRODARCH@UNTHSC> sta Prov_Compile.sql Wrote file Instem_SQLPlusEnv.sql Compiling invalid objects, please wait... Compilation complete. Still Invalid ------------- 0 PRODARCH@UNTHSC> conn PRODCOPY Connected. PRODCOPY@UNTHSC> sta Prov_Compile.sql Wrote file Instem_SQLPlusEnv.sql Compiling invalid objects, please wait... Compilation complete. Still Invalid ------------- 0 PRODCOPY@UNTHSC> CONN TRAIN Connected. TRAIN@UNTHSC> sta Prov_Compile.sql Wrote file Instem_SQLPlusEnv.sql Compiling invalid objects, please wait... Compilation complete. Still Invalid ------------- 0 TRAIN@UNTHSC> conn TRAINARCH Connected. TRAINARCH@UNTHSC> sta Prov_Compile.sql Wrote file Instem_SQLPlusEnv.sql Compiling invalid objects, please wait... Compilation complete. Still Invalid ------------- 0 TRAINARCH@UNTHSC> conn TRAINCOPY Connected. TRAINCOPY@UNTHSC> sta Prov_Compile.sql Wrote file Instem_SQLPlusEnv.sql Compiling invalid objects, please wait... Compilation complete. Still Invalid ------------- 0 TRAINCOPY@UNTHSC> conn PRODARCH Connected. PRODARCH@UNTHSC> sta WBArch_Grant.sql Enter User requiring Privileges: PROD Please wait... Completed. PRODARCH@UNTHSC> conn TRAINARCH Connected. TRAINARCH@UNTHSC> sta WBArch_Grant.sql Enter User requiring Privileges: TRAIN Please wait... Completed. TRAINARCH@UNTHSC> conn PRODCOPY Connected. PRODCOPY@UNTHSC> sta WBArch_Grant.sql Enter User requiring Privileges: PROD Please wait... Completed. PRODCOPY@UNTHSC> conn TRAINCOPY Connected. TRAINCOPY@UNTHSC> sta WBArch_Grant.sql Enter User requiring Privileges: TRAIN Please wait... Completed. TRAINCOPY@UNTHSC> spool off