LEHS - Log- and Exception-Handling System for ORACLE®

What is LEHS

LEHS means Log- and Exception-Handling System.
It is a system to maintain a database wide platform for user defined exceptions and for application logging like the popular project LOG4J.

Why use LEHS

There are other projects out there achieving roughly the same.
For Instance: So, why should you use LEHS then?

Features of LEHS

New Features with Release 2.0

New Features with Release 2.1

New Features with Release 2.2


LEHS is completely developed in PL/SQL. Therefor it only runs on ORACLE® databases.
Because LEHS uses the function DBMS_UTILITY.format_error_backtrace it only runs on ORACLE® Database 10gR2 and above.

Contact me

In case of questions, enhancements, trouble shooting etc. please contact me by .