Rem
Rem $Header: sdk_sqltrace_pkgdef.sql 15-jul-2005.05:31:17 scgrover Exp $
Rem
Rem sdk_sqltrace_pkgdef.sql
Rem
Rem Copyright (c) 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      sdk_sqltrace_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    scgrover    07/15/05 - scgrover_add_dbms_job_extended_sql_trace
Rem    scgrover    07/06/05 - Created
Rem

CREATE or REPLACE PACKAGE MGMT_SQLTRACE AS

PROCEDURE EXTENDED_SQL_TRACE(p_trace_name IN VARCHAR2);

PROCEDURE EXTENDED_SQL_TRACE_ON(p_trace_name IN VARCHAR2, p_value IN BOOLEAN);

EST_ON               CONSTANT VARCHAR2(2) := 'ON';
EST_OFF              CONSTANT VARCHAR2(3) := 'OFF';

EST_LOG_NAME         CONSTANT VARCHAR2(32) := 'EXTENDED SQL TRACE';
EST_LOG_DISPLAY_NAME CONSTANT VARCHAR2(32) := 'Extended Sql Trace';

END MGMT_SQLTRACE;
/
show errors;