Rem drv: Rem Rem $Header: license_data_upgrade.sql 04-dec-2005.21:37:37 bram Exp $ Rem Rem license_data_upgrade.sql Rem Rem Copyright (c) 2005, Oracle. All rights reserved. Rem Rem NAME Rem license_data_upgrade.sql - Rem Rem DESCRIPTION Rem Rem Rem NOTES Rem For Customers who are on 10.2 and who are upgrading to 10.2.0.2 this file will be called Rem Rem MODIFIED (MM/DD/YY) Rem bram 12/04/05 - Created Rem @&EM_SQL_ROOT/core/10.2.0.2/license/license_post_creation.sql -- Change Description for Bug-4777882--TARGET TYPE "SLB" TO BE ASSOCIATED WITH SMND PACK AND NOT SMS PACK -- As a result of the change description,the pack_name need to be updated to -- for all Rows in mgmt_licensed_targets which correspond to target_guid= -- 1)get all target_guid from mgmt_targets whose target-type='slb' and those which have a matching entry in mgmt_licensed_targets -- For each of the target_guid,Update mgmt_licensed_targets update pack_label='nd_smp' -- 2) BEFORE UPDATE --ROW IN MGMT_LICENSED_TARGETS -- -- -- AFTER UPDATE -- DECLARE TYPE l_target_guid_table IS TABLE OF mgmt_targets.TARGET_GUID%TYPE INDEX BY BINARY_INTEGER; l_target_guid_arr l_target_guid_table; BEGIN SELECT lic.target_guid BULK COLLECT INTO l_target_guid_arr FROM mgmt_licensed_targets lic,mgmt_targets tar WHERE lic.target_guid=tar.target_guid AND tar.target_type='slb'; IF (l_target_guid_arr IS NOT NULL) AND (l_target_guid_arr.count>0) THEN FOR i IN 1..l_target_guid_arr.count LOOP UPDATE MGMT_LICENSED_TARGETS SET pack_name='nd_smp' WHERE pack_name='storage_smp' AND target_guid=l_target_guid_arr(i); END LOOP; END IF; COMMIT; END; /