Rem
Rem $Header: storage_common_db_utils_pkgdef.sql 17-may-2005.09:54:36 ajdsouza Exp $
Rem
Rem storage_common_db_utils_pkgdef.sql
Rem
Rem Copyright (c) 2004, 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      storage_common_db_utils_pkgdef.sql - <one-line expansion of the name>
Rem
Rem    DESCRIPTION
Rem      Utilities used by storage for accessing db/asm/rac target information
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    ajdsouza    04/25/05 - Use type MGMT_STORAGE_STRING_TABLE
Rem    ajdsouza    09/20/04 - ajdsouza_storage_fix1
Rem    ajdsouza    09/07/04 - Created
Rem

Rem SET ECHO ON
Rem SET FEEDBACK 1
Rem SET NUMWIDTH 10
Rem SET LINESIZE 80
Rem SET TRIMSPOOL ON
Rem SET TAB OFF
Rem SET PAGESIZE 100

CREATE OR REPLACE PACKAGE storage_common_db_utils AS

  FUNCTION get_oracle_db_targets 
   ( 
     v_host_name mgmt_targets.host_name%TYPE 
   )
   RETURN  MGMT_METRIC_INSTANCE_ARRAY;
  
  FUNCTION get_os_entities_for_orcl_tgts
   (
     v_target_name   mgmt_targets.target_name%TYPE,
     v_target_type   mgmt_targets.target_type%TYPE
   )
    RETURN MGMT_STORAGE_STRING_TABLE;

END storage_common_db_utils;
/