add built-in context variables 'PROC_NAME' and 'ERROR_LINE' and database level
trigger that fires on any ERROR
--------------------------------------------------------------------------------------------------------------
Key: CORE-3587
URL: http://tracker.firebirdsql.org/browse/CORE-3587
Project: Firebird Core
Issue Type: Improvement
Reporter: Pavel Zotov
Currently there is no way to obtain the point of stored procedure that faults
(i.e. when error occurs in some sp "A" we can not see on *server* side what
exact statement lead to error). Consequently we can not to automate such task
as logging of errors by SERVER program units.
I think that introducing of two new context variables will be useful. These
variables should store the name of currently executing SP and the LINE of
currently executed statement in this SP.
In such case if we had DB-level trigger that fires on any error the task of
PRECISE logging could be done easy (by call in autonomous transaction INSERT
INTO T_LOG ... from this trigger; no need to write thousands WHEN-handlers in
each SP).
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
EMC VNX: the world's simplest storage, starting under $10K
The only unified storage solution that offers unified management
Up to 160% more powerful than alternatives and 25% more efficient.
Guaranteed. http://p.sf.net/sfu/emc-vnx-dev2dev
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
