Rem drv: <create type="pkgdefs"/>
Rem
Rem $Header: textManager_pkgdefs.sql 03-jul-2006.01:57:39 ganessub Exp $
Rem
Rem textManager_pkgdefs.sql
Rem
Rem Copyright (c) 2006, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      textManager_pkgdefs.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    ganessub    06/26/06 - Created
Rem

CREATE OR REPLACE PACKAGE MGMT_TEXT AS

-- Package level Type Definition
   TYPE cursorType IS REF CURSOR;

/*
Store a log entry for a text index.
*/
procedure addTextLog(
        i_indexName  IN VARCHAR2,
        i_schemaName IN VARCHAR2,
        i_targetName IN VARCHAR2,
        i_targetType IN VARCHAR2,
        i_logDir     IN VARCHAR2,
        i_logFile    IN VARCHAR2,
        i_appendMode IN BOOLEAN,
        i_actionType IN VARCHAR2);

/*
 Creates a new unique Text Index GUID record if 
 does not exist otherwise returns existing Text Index GUID.
*/
procedure createUniqueTextIndexRecord(
       i_indexName  IN VARCHAR2,
       i_schemaName IN VARCHAR2,
       i_targetGUID IN RAW,
       o_textIndexGUID OUT RAW);

end MGMT_TEXT;
/
show errors;