Contents tagged with Autonomous
-
Oracle Pragma Autonomous Transaction
CREATE FUNCTION FN_MYAPP_WS_LOGGERreturn VARCHAR2as PRAGMA AUTONOMOUS_TRANSACTION;BEGIN
/* needs grant select on v$session (or any dictionary), but not via role */INSERT INTO MYAPP_WS_LOGGERSELECT * … more
-
How to create an autonomous transaction in SQL Server 2008
https://blogs.msdn.microsoft.com/sqlprogrammability/2008/08/22/how-to-create-an-autonomous-transaction-in-sql-server-2008/
http://www.sqlines.com/oracle/pragma_autonomous_transaction
http://www.c- … more
-
Autonomous Transactions in SQL Server
https://www.dbbest.com/blog/autonomous-transactions-sql-server/
https://stackoverflow.com/questions/45731207/commit-transaction-outside-the-current-transaction-like-autonomous-transaction