Rem
Rem $Header: emcore/source/oracle/sysman/emdrep/sql/core/12.1.0.3/emInternalSDK/events/events_types.sql rbali_oneoff_updated/1 2025/03/14 06:41:13 rbali Exp $
Rem
Rem events_types.sql
Rem
Rem Copyright (c) 2012, 2025, Oracle and/or its affiliates. 
Rem All rights reserved.

Rem BEGIN EMRU_FILE_METADATA
Rem EMRU_SOURCE_FILE:emcore/source/oracle/sysman/emdrep/sql/core/12.1.0.3/emInternalSDK/events/events_types.sql
Rem EMRU_UNIX_DELIVERABLES:
Rem emcore/source/oracle/sysman/emdrep/sql/core/12.1.0.3/emInternalSDK/events/events_types.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      events_types.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    gbafna      01/07/25 - make synonyms noneditionable
Rem    rnadidar    02/11/15 - cut over to EBR
Rem    zeding      07/31/12 - Created
Rem

ALTER SESSION SET CURRENT_SCHEMA=SYSMAN_TYPES;

-- message param that allows exact type to be specified
-- p_type based on even context type value
-- 0 for String
-- 1 for Number 
CREATE OR REPLACE TYPE gc_ev_msg_param AS OBJECT (
  value        VARCHAR2(4000),
  nlsid        VARCHAR2(256),
  resbundle    VARCHAR2(512),
  type         NUMBER(1),
 CONSTRUCTOR FUNCTION gc_ev_msg_param (
  p_value      IN VARCHAR2,
  p_nlsid      IN VARCHAR2,
  p_resbundle  IN VARCHAR2
 )
 RETURN SELF AS RESULT,
 CONSTRUCTOR FUNCTION gc_ev_msg_param (
  p_value  IN VARCHAR2
 )
 RETURN SELF AS RESULT,
 CONSTRUCTOR FUNCTION gc_ev_msg_param (
  p_value  IN NUMBER
 )
 RETURN SELF AS RESULT
);
/

grant execute on gc_ev_msg_param to sysman;

create or replace noneditionable synonym SYSMAN.gc_ev_msg_param for gc_ev_msg_param;


-- message param array
CREATE OR REPLACE TYPE GC_EV_MSG_PARAM_ARRAY AS VARRAY(20) of gc_ev_msg_param;
/

grant execute on GC_EV_MSG_PARAM_ARRAY to sysman;

create or replace noneditionable synonym SYSMAN.GC_EV_MSG_PARAM_ARRAY for GC_EV_MSG_PARAM_ARRAY;


ALTER SESSION SET CURRENT_SCHEMA=SYSMAN;




