I'd be interested if there is an answer to this. The big issue with writing to a table is the interaction with rollbacks and commits.
Even more difficult in PG functions as they have no commit / rollback capability. I haven't played with stored procedures in in PG11 yet. In Oracle, I wrote logging / error messages to a logging file on the fire system, directly from PL/SQL. This file can then be monitored for error messages via a messaging solutions. Regards On Mon, 29 Oct 2018 at 19:13, Patrick FICHE <patrick.fi...@aqsacom.com> wrote: > 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.fi...@aqsacom.com > > > > [image: 01-03_AQSA_Main_Corporate_Logo_JPEG_White_Low.jpg] > <http://www.aqsacom.com/> > > >
