Rem drv:
Rem
Rem $Header: credentials_schema_upgrade.sql 08-sep-2005.18:06:10 skini Exp $
Rem
Rem credentials_schema_upgrade.sql
Rem
Rem Copyright (c) 2005, Oracle. All rights reserved.
Rem
Rem NAME
Rem credentials_schema_upgrade.sql -
Rem
Rem DESCRIPTION
Rem
Rem
Rem NOTES
Rem
Rem
Rem MODIFIED (MM/DD/YY)
Rem skini 09/08/05 - Change container_location to 1024
Rem neearora 09/05/05 - Chk USER_NAME length before altering
Rem MGMT_CRED_RECORD
Rem neearora 09/02/05 - Removed ALTER TYPE MGMT_CRED_RECORD
Rem neearora 09/01/05 - neearora_bug-4582517
Rem neearora 08/31/05 - Created
Rem
BEGIN
EXECUTE IMMEDIATE 'DROP TYPE &&EM_REPOS_USER..MGMT_CRED_SET_COL_ARRAY';
EXCEPTION
WHEN OTHERS THEN
IF(SQLCODE != -4043)THEN -- Object does not exist
RAISE;
END IF;
END;
/
BEGIN
EXECUTE IMMEDIATE 'DROP TYPE &&EM_REPOS_USER..MGMT_CRED_SET_COL_RECORD';
EXCEPTION
WHEN OTHERS THEN
IF(SQLCODE != -4043)THEN -- Object does not exist
RAISE;
END IF;
END;
/
CREATE OR REPLACE TYPE MGMT_CRED_SET_COL_RECORD AS OBJECT (
type_column_name VARCHAR2(64),
set_column_name VARCHAR2(64),
set_column_display_name VARCHAR2(64),
set_column_display_nlsid VARCHAR2(64),
set_column_values MGMT_CRED_SET_COL_VAL_ARRAY,
CONSTRUCTOR FUNCTION MGMT_CRED_SET_COL_RECORD (
type_column_name VARCHAR2,
set_column_name VARCHAR2,
set_column_display_name VARCHAR2,
set_column_display_nlsid VARCHAR2)
RETURN SELF AS RESULT
);
/
CREATE OR REPLACE TYPE MGMT_CRED_SET_COL_ARRAY AS
TABLE OF MGMT_CRED_SET_COL_RECORD;
/
ALTER TABLE MGMT_CONTAINER_CREDENTIALS MODIFY (container_location VARCHAR2(1024));
DECLARE
user_name_len NUMBER;
BEGIN
SELECT length
INTO user_name_len
FROM all_type_attrs
WHERE type_name = 'MGMT_CRED_RECORD'
AND attr_name = 'USER_NAME';
IF(user_name_len < 256) THEN
EXECUTE IMMEDIATE 'ALTER TYPE &&EM_REPOS_USER..MGMT_CRED_RECORD MODIFY ATTRIBUTE USER_NAME VARCHAR2(256) CASCADE';
END IF;
END;
/