begin :id := sys.dbms_transaction.local_transaction_id; end;问题

我在session 876中執行完下面sql后
select * from table
在到另一session中執行
SELECT   /*+ ORDERED */
         sql_text
    FROM v$sqltext a
   WHERE (a.hash_value, a.address) IN (
            SELECT DECODE (sql_hash_value,0,prev_hash_value,sql_hash_value),
                   DECODE (sql_hash_value,0,prev_sql_addr,  sql_address)
              FROM v$session b   where sid=876)
order by a.piece;
結果老是出來這個
begin :id := sys.dbms_transaction.local_transaction_id; end;

这是由于session是通过plsql执行的。