Rem drv: <migrate type="schema_upgrade" version="13.4.0.0"/>
Rem
Rem $Header: emcore/source/oracle/sysman/emdrep/sql/core/13.4.0.0/sdk/sdk_types_upgrade.sql rbali_oneoff_updated/1 2025/03/14 06:41:13 rbali Exp $
Rem
Rem sdk_types_upgrade.sql
Rem
Rem Copyright (c) 2019, 2025, Oracle and/or its affiliates.

Rem BEGIN EMRU_FILE_METADATA
Rem EMRU_SOURCE_FILE:emcore/source/oracle/sysman/emdrep/sql/core/13.4.0.0/sdk/sdk_types_upgrade.sql
Rem EMRU_UNIX_DELIVERABLES:
Rem emcore/source/oracle/sysman/emdrep/sql/core/13.4.0.0/sdk/sdk_types_upgrade.sql

Rem EMRU_FILE_POSTINSTALL:<!!! enter the view based location of the executable file. If there is NONE leave as-is !!!>
Rem EMRU_GENERIC_FLAG:NONE
Rem END EMRU_FILE_METADATA

Rem
Rem    NAME
Rem      sdk_types_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    BEGIN SQL_FILE_METADATA
Rem    SQL_SOURCE_FILE: emcore/source/oracle/sysman/emdrep/sql/core/13.4.0.0/sdk/sdk_types_upgrade.sql
Rem    SQL_SHIPPED_FILE:
Rem    SQL_PHASE:
Rem    SQL_STARTUP_MODE: NORMAL
Rem    SQL_IGNORABLE_ERRORS: NONE
Rem    END SQL_FILE_METADATA
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    gbafna      01/07/25 - make synonyms noneditionable
Rem    shrikris    06/14/19 - add new type(s) during upgrade
Rem    shrikris    06/14/19 - Created
Rem

ALTER SESSION SET CURRENT_SCHEMA=SYSMAN_TYPES;

/**
* Use this type as a variable when the select is very large e.g. for a large number of targets
*/
CREATE OR REPLACE TYPE MGMT_INTEGER_ARRAY_LARGE AS VARRAY(100000) OF INTEGER;
/

grant execute on MGMT_INTEGER_ARRAY_LARGE to sysman;

create or replace noneditionable synonym SYSMAN.MGMT_INTEGER_ARRAY_LARGE for MGMT_INTEGER_ARRAY_LARGE;

ALTER SESSION SET CURRENT_SCHEMA=SYSMAN;


