Even more difficult in PG functions as they have no commit / rollback
capability. I haven't played with stored procedures in in PG11 yet.
You can simulate oracle autonomous transaction feature in postgres by
connecting to the same db using dblink.
As for implicit passing of error
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
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 /
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 /
