What is the oracle autonomous transaction?

This article mainly talks about "what is the autonomous affairs of oracle". Interested friends may wish to have a look at it. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn what oracle autonomous affairs are.

CREATE OR REPLACE PROCEDURE PRC_TEST AS

/ *

Author:xjf

Date:2090817

Desc:

, /

Define stored procedures that are written to the log as autonomous transactions

PROCEDURE INNER_PRC_LOG AS

PRAGMA AUTONOMOUS_TRANSACTION;-designated as an autonomous transaction

BEGIN

DBMS_OUTPUT.PUT_LINE ('['| | LPAD ($PLSQL_UNIT, 50,'') | |'] line'| |

LPAD ($PLSQL_LINE, 4,'') | |':'| |

TO_CHAR (SYSDATE, 'HH:MI:SS'))

INSERT INTO TB_TRACE (IN_TIME) VALUES (SYSDATE)

COMMIT;-must be explicitly committed in an autonomous transaction

END

BEGIN

INNER_PRC_LOG;-- call

INSERT INTO TB_TRACE (IN_TIME) VALUES (SYSDATE)

EXCEPTION

WHEN OTHERS THEN

INNER_PRC_LOG;-- call

END

At this point, I believe you have a deeper understanding of "what is the autonomous affairs of oracle". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!