You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Example:
CREATE OR ALTER TRIGGER TRG_TRANS_START
ACTIVE ON TRANSACTION START POSITION 0
AS
BEGIN
IN AUTONOMOUS TRANSACTION DO
INSERT INTO SOMETABLE
(ID)
VALUES
(1);
END
The bug reason is that code, which rolled back just created but failed transaction was not entered engine, i.e. rollback() was called outside of engine.
Submitted by: Maxim Kuzmin (cybermax)
Example:
CREATE OR ALTER TRIGGER TRG_TRANS_START
ACTIVE ON TRANSACTION START POSITION 0
AS
BEGIN
IN AUTONOMOUS TRANSACTION DO
INSERT INTO SOMETABLE
(ID)
VALUES
(1);
END
Commits: 3ddc20a 07970b1 d49336c
The text was updated successfully, but these errors were encountered: