In this series of posts about frameworks for PL/SQL, today I present the links for the free PL/SQL Error and Log Libraries that I know of:
Quest Error Manager also called QEM
Log 4 PLSQL
Logger
PL/SQL Log & DBug Library
PLJ_LG
I use QEM as I have showed in a previous post.
Showing posts with label Error Manager. Show all posts
Showing posts with label Error Manager. Show all posts
2010-11-29
2010-10-25
2010-09-23
QEM 1.4.0 available
A new version (1.4.0) of Quest Error Manager is available
Changes since previous version (1.3.8)
----------------
* add error_category_name field to error_info_rt
* minor re-factoring
* add more last_* functions and last_error_info function to return the record
* add option to disregard the remaining_context in the message
Changes since previous version (1.3.8)
----------------
* add error_category_name field to error_info_rt
* minor re-factoring
* add more last_* functions and last_error_info function to return the record
* add option to disregard the remaining_context in the message
2010-07-25
QEM version 1.3.8 available
A new version (1.3.8) of Quest Error Manager is available
Changes since previous version (1.3.7)
----------------
* make register_error truncate text_in to 4000 to make the insert possible
(thanks to Bill Pribyl for reporting)
* add truncate to 4000 to DBMS_UTILITY.format* output when storing to table
Changes since previous version (1.3.7)
----------------
* make register_error truncate text_in to 4000 to make the insert possible
(thanks to Bill Pribyl for reporting)
* add truncate to 4000 to DBMS_UTILITY.format* output when storing to table
2010-03-30
Quest Error Manager new version and forum
Quest Error Manager has now a new version (1.3.7)
That version has the following changes (made by me with Steve "blessing"):
1)add trigger to populate environmental info to q$error_context
2)q$error_instance_ir trigger: add web environment variables log (if available)
3)corrected commentaries in example scripts and cleaned unused variables
4)add missing example file from the last versions: QEM in APEX
1) is very important if you want to use partitioned tables
Also a new forum for Quest Error Manager discussion has open http://qem.inside.quest.com/ and I am one of the moderators and will try to answer any question. Some threads from the CodeGen forum where discussions about QEM were made have been moved to this new forum.
That version has the following changes (made by me with Steve "blessing"):
1)add trigger to populate environmental info to q$error_context
2)q$error_instance_ir trigger: add web environment variables log (if available)
3)corrected commentaries in example scripts and cleaned unused variables
4)add missing example file from the last versions: QEM in APEX
1) is very important if you want to use partitioned tables
Also a new forum for Quest Error Manager discussion has open http://qem.inside.quest.com/ and I am one of the moderators and will try to answer any question. Some threads from the CodeGen forum where discussions about QEM were made have been moved to this new forum.
2009-06-12
QEM unofficial Forum gets official support
Quest Error Manager has an unofficial forum in a section of QCGU Foruns.
I gave some assistance to people there (and answering some direct emails send to me) about QEM.
Now that forum has official "support" from Steven.
If you have some trouble with QEM or some insights please post there some all the community can learn/help/question.
Regards
I gave some assistance to people there (and answering some direct emails send to me) about QEM.
Now that forum has official "support" from Steven.
If you have some trouble with QEM or some insights please post there some all the community can learn/help/question.
Regards
2008-11-10
Quest Error Manager new version
Quest Error Manager (QEM) has a new version that incorporates the fixes and improves I send to Steven
(the fixes for the bugs I found (raise error when only log was expected, the size limit on some variables, the trigger to populate the log table automatically with some debug info and a new procedure to get the log code out).
(the fixes for the bugs I found (raise error when only log was expected, the size limit on some variables, the trigger to populate the log table automatically with some debug info and a new procedure to get the log code out).
2008-07-18
Bugs in Quest Error Manager
I found some bugs in the Quest Error Manager (QEM).
So I changed q$error_manager package. The changes I made soo far are:
So I changed q$error_manager package. The changes I made soo far are:
Subscribe to:
Posts (Atom)