Function for Exception Logging

Hi community,

I would like to implement a function that would log managed Exceptions into a dedicated table.

For example, I have some code like :

BEGIN

Code generation exception

EXCEPTION

  WHEN OTHERS THEN Log_Error();

END;

The Log_Error function would be able to get the exception context / parameters to log the exception parameters into a table.

Is there any way to manage this without providing the Exception parameters as parameters to the Log_Error function ?

Thanks,

Patrick

Patrick Fiche

Database Engineer, Aqsacom Sas.

c. 33 6 82 80 69 96

e. patrick.fiche@aqsacom.com