Rem drv: <migrate type="data_upgrade" version="10.2.0.4"/>
Rem $Header: ocs_test_upgrade.sql 14-may-2007.04:11:56 skpanigr Exp $
Rem
Rem ocs_test_upgrade.sql
Rem
Rem Copyright (c) 2007, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      ocs_test_upgrade.sql - <one-line expansion of the name>
Rem
Rem    DESCRIPTION
Rem      <short description of component this file declares/defines>
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    skpanigr    05/09/07 - skpanigr_bug-5963527
Rem    skpanigr    05/09/07 - Created
Rem

BEGIN
    UPDATE mgmt_test_metric_props 
        SET encrypt='Y' WHERE metric_name='imap_response' and property_name='imap_password';
    UPDATE mgmt_test_metric_props 
        SET encrypt='Y' WHERE metric_name='pop_response' and property_name='pop_password';
    UPDATE mgmt_test_metric_props 
        SET encrypt='Y' WHERE metric_name='ldap_response' and property_name='ldap_password';
EXCEPTION
	WHEN OTHERS THEN NULL;
END;
/