?? pslogparam.sql
/*<TOAD_FILE_CHUNK>*/
CREATE OR REPLACE
PACKAGE PLOGPARAM IS
/**
* package name : PLOGPARAM
*<br/>
*<br/>
*See : <a href="http://log4plsql.sourceforge.net">http://log4plsql.sourceforge.net</a>
*<br/>
*<br/>
*Objectif : Store updatable paramter for PLOG.
*<br/><br/><br/><br/>
* This package is create befort PLOG
*<br/><br/><br/>
*
*
*@headcom
*<br/>
*<br/>
*<br/>
*History who date comment
*V3 Guillaume Moulard 05-AUG-03 Creation
*<br/>
*<br/>
* Copyright (C) LOG4PLSQL project team. All rights reserved.<br/>
*<br/>
* This software is published under the terms of the The LOG4PLSQL <br/>
* Software License, a copy of which has been included with this<br/>
* distribution in the LICENSE.txt file. <br/>
* see: <http://log4plsql.sourceforge.net> <br/><br/>
*
*/
-------------------------------------------------------------------
-- Constants (tools general parameter)
-- you can update regard your context
-------------------------------------------------------------------
-- LERROR default level for production system.
-- DEFAULT_LEVEL CONSTANT TLOG.LLEVEL%type := 30 ; -- LERROR
-- LDEBUG for developement phase
DEFAULT_LEVEL CONSTANT TLOG.LLEVEL%type := 30 ; -- LERROR
-- TRUE default value for Logging in table
DEFAULT_LOG_TABLE CONSTANT BOOLEAN := TRUE;
-- if DEFAULT_USE_LOG4J is TRUE log4j Log4JbackgroundProcess are necessary
DEFAULT_USE_LOG4J CONSTANT BOOLEAN := FALSE;
-- TRUE default value for Logging out off transactional limits
DEFAULT_LOG_OUT_TRANS CONSTANT BOOLEAN := TRUE;
-- if DEFAULT_LOG_ALERTLOG is true the log is write in alert.log file
DEFAULT_LOG_ALERT CONSTANT BOOLEAN := FALSE;
-- if DEFAULT_LOG_TRACE is true the log is write in trace file
DEFAULT_LOG_TRACE CONSTANT BOOLEAN := FALSE;
-- if DEFAULT_DBMS_OUTPUT is true the log is send in standard output (DBMS_OUTPUT.PUT_LINE)
DEFAULT_DBMS_OUTPUT CONSTANT BOOLEAN := FALSE;
-- default level for asset
DEFAULT_ASSET_LEVEL CONSTANT TLOG.LLEVEL%type := DEFAULT_LEVEL ;
-- default level for call_stack_level
DEFAULT_FULL_CALL_STACK_LEVEL CONSTANT TLOG.LLEVEL%type := DEFAULT_LEVEL ;
-- use for build a string section
DEFAULT_Section_sep CONSTANT TLOG.LSECTION%type := '.';
-- default PIPE_NAME
DEFAULT_DBMS_PIPE_NAME CONSTANT VARCHAR2(255) := 'LOG_PIPE';
-- Formats output sent to DBMS_OUTPUT to this width.
DEFAULT_DBMS_OUTPUT_LINE_WRAP CONSTANT NUMBER := 100;
END PLOGPARAM;
/
/*<TOAD_FILE_CHUNK>*/
-------------------------------------------------------------------
-- End of document
-------------------------------------------------------------------
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -