Log 4 pl/sql

Oracle Database Logging tools

LOG4PLSQL is a PLSQL framework for logging in all PLSQL code

• Package,
• Procedure,
• Function,
• Trigger,
• PL/SQL Web application,
• Oracle Tools (Form, report,…).

Purpose:

• Easy of implemented and use
• Possibility to log apart from transaction
• Possibility to adapt the level of logging depending on user requirements
• Ability to use all LOG4J feature.
• Provide a complet set of tools PL/SQL developpement (bebug variable, SQLERRM, assert, call stack, ... ).

Log destination:

• Table in Oracle Datablase
• Oracle Datablase alert.log file
• Oracle Datablase trace file
• Standard output
• session information (view V$SESSION)
• By log4J::Log4JbackgroundProcess:

  • Async,

  • JDBC,

  • JMS,

  • NTEventLog,

  • SMTP,

  • Socket,

  • SocketHub,

  • Syslog,

  • Telnet,

  • Writer

Log4plsql was born from the log4J spirit (and use it).

• LOG4PLSQL: User Guide
• License
• log4j documentation
• Oracle (doc)

• LOG4PLSQL
• required lib (Only for V2 and Log4JbackgroundProcess)
• Tora Integration: TOra is a Toolkit for Oracle which aims to help the DBA or developer of database application. Features PL/SQL debugger, SQL worksheet with syntax highlighting, DB browser and a comprehensive set of DBA tools. For using LOG4PLSQL with TOra download log4plsql.tpl