Hello, Ok, well. My use case is in short words:
Some SPs calling other SPs with dynamically built SQL code executed with execute statement or for execute loops. Error handling is hardened with a when any statement after special handling of "expected" errors. In that when any block I write in an autonomous transaction a log entry to a table. Of course SQLCode, GDSCode are logged beside some proc specific information about the line where exception was raised. How can I get the additional info which firebird client could get from the exception but which is currently not available inside sp code. I do not want to show the message itself to a user but I want to get hints for debugging. And it's not an option to let SP return to Client in case of error without an when any block because many records are processed in the SPs and I want to track the record with a problem I'd suggest an new mon$-Table-Set: MON$EXCEPTION with info about where an exception was raised and what type of exception and additional infos (e.G. SQLCode or SQLError) MON$CALL_EXCEPTION_PARAMS with a list of params for a specific exception. May be an additional reference from MON$CALL_STACK to MON$CALL_EXCEPTION would be possible. Björn -- Björn Reimer - RRZE ------------------------------------------------------------------------------ Don't Limit Your Business. Reach for the Cloud. GigeNET's Cloud Solutions provide you with the tools and support that you need to offload your IT needs and focus on growing your business. Configured For All Businesses. Start Your Cloud Today. https://www.gigenetcloud.com/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
