Rem drv: <create type="pkgdefs"/>
Rem
Rem $Header: emdb/source/oracle/sysman/emdrep/sql/db/latest/policy/config_util_pkgdef.sql /st_emdbsa_11.2/2 2011/05/20 10:15:53 mpawelko Exp $
Rem
Rem config_util_pkgdef.sql
Rem
Rem Copyright (c) 2008, 2011, Oracle and/or its affiliates. 
Rem All rights reserved. 
Rem
Rem    NAME
Rem      config_util_pkgdef.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    mpawelko    04/26/11 - Backport mnihalan_bug-8837510_2 from
Rem                           st_emdbgc_10.2.0.1.0
Rem    mnihalan    05/07/08 - Utils for config policies
Rem    mnihalan    05/07/08 - Created
Rem

CREATE OR REPLACE PACKAGE CONFIG_UTIL
IS

TYPE RESULT_CURSOR IS REF CURSOR;

-- Function to return a concatenated list (space delimited by default) a the
-- given table and column, restricted by given predicate.
-- If the max varchar2 length is exceeded (VALUE_ERROR) a truncated
-- result is returned.
--  COL      The name of the column, from the tab passed int.
--  TAB      The table (or query in parens) from which to select the column.
--  PREDICATE - Used in a where clause to restrict the selection.
--  DELIMETER   Used to separate the column values in the returned string.
--  COL_LIMIT   Used to limit the number of COL values to return. If more then
--              this limit exists the return string has an ellipsis added at
--              the end
FUNCTION CONCAT_FILE_NAME ( COL VARCHAR2,
                        TAB VARCHAR2,
                        PREDICATE VARCHAR2,
                        BIND_VAR  VARCHAR2,
                        DELIMETER VARCHAR2 := ' ',
                        COL_LIMIT NUMBER := -1)
RETURN VARCHAR2;

  FUNCTION CONCAT_RESULT_COL ( c1 RESULT_CURSOR,
    DELIMETER VARCHAR2 := ' ',
    COL_LIMIT NUMBER := -1)
  RETURN VARCHAR2;

  FUNCTION REDO_FILE_LIST( p_snapshot_guid IN VARCHAR2)
  RETURN VARCHAR2;

  FUNCTION REDO_GROUP_NUM_LIST( p_snapshot_guid IN VARCHAR2)
  RETURN VARCHAR2;

  FUNCTION CONTROL_FILE_LIST( p_snapshot_guid IN VARCHAR2)
  RETURN VARCHAR2;

END CONFIG_UTIL;
/
show errors;