معاملات بدون جلسه در پایگاه داده 23AI (23.6)

DBMS_TRANSACTION.START_TRANSACTION(
   xid              in raw default null,
   transaction_type in pls_integer default TRANSACTION_TYPE_LOCAL,
   timeout          in pls_integer default 60,
   flag             in pls_integer default 0
) RETURN VARCHAR2;

SQL> create table tbl_sessionless (id number,First_name varchar2(20),last_name varchar2(30));
Table created.

SQL> select sid from v$mystat where rownum=1;
       SID
----------
       138

SQL> set serveroutput on
SQL> declare
  TRANID VARCHAR2(128);
begin
  TRANID := DBMS_TRANSACTION.START_TRANSACTION
  ( XID              => UTL_RAW.CAST_TO_RAW('Arsenal01')
  , transaction_type => DBMS_TRANSACTION.TRANSACTION_TYPE_SESSIONLESS
  , timeout          => 5
  , flag             => DBMS_TRANSACTION.TRANSACTION_NEW
  );
 dbms_output.put_line('TRANID is: ' || TRANID);
end;
/
TRANID is: 417273656E616C3031
PL/SQL procedure successfully completed.

SQL> insert into tbl_sessionless values(1,'Vahid','Yousefzadeh');
1 row created.

SQL> select * from tbl_sessionless;
        ID FIRST_NAME           LAST_NAME
---------- -------------------- ------------------------------
         1 Vahid                Yousefzadeh

SQL> execute DBMS_TRANSACTION.SUSPEND_TRANSACTION;
PL/SQL procedure successfully completed.

SQL> exit

SQL> select sid from v$mystat where rownum=1;
       SID
----------
       507

SQL> select * from tbl_sessionless;
no rows selected

SQL> set serveroutput on
SQL> declare
    TRANID VARCHAR2(128);
begin
    TRANID := DBMS_TRANSACTION.START_TRANSACTION
    ( xid              => UTL_RAW.CAST_TO_RAW('Arsenal01')
    , transaction_type => DBMS_TRANSACTION.TRANSACTION_TYPE_SESSIONLESS
    , flag             => DBMS_TRANSACTION.TRANSACTION_RESUME
    );
dbms_output.put_line('Resumed TRANID: '||TRANID);
end;
/
Resumed TRANID: 417273656E616C3031
PL/SQL procedure successfully completed.

SQL> select * from tbl_sessionless;
        ID FIRST_NAME           LAST_NAME
---------- -------------------- ------------------------------
         1 Vahid                Yousefzadeh

SQL> select s.sid,s.TADDR,s.PROGRAM from v$transaction t,v$session s where t.ADDR=s.TADDR;
       SID TADDR            PROGRAM
---------- ---------------- ------------------------------
       507 00000000CB5651E8 sqlplus@OEL9 (TNS V1-V3)

SQL> commit;
Commit complete.

SQL> select * from tbl_sessionless;
        ID FIRST_NAME           LAST_NAME
---------- -------------------- ------------------------------
         1 Vahid                Yousefzadeh

SQL> set serveroutput on
SQL> declare
    TRANID VARCHAR2(128);
begin
    TRANID := DBMS_TRANSACTION.START_TRANSACTION
    ( xid              => UTL_RAW.CAST_TO_RAW('Arsenal01')
    , transaction_type => DBMS_TRANSACTION.TRANSACTION_TYPE_SESSIONLESS
    , flag             => DBMS_TRANSACTION.TRANSACTION_RESUME
    );
dbms_output.put_line('Resumed TRANID: '||TRANID);
end;
/
ORA-26218: sessionless transaction with GTRID 417273656E616C3031 does not
exist.
ORA-06512: at "SYS.DBMS_TRANSACTION", line 299
ORA-06512: at line 4
Help: https://docs.oracle.com/error-help/db/ora-26218/