PL/SQL 8.0.5 - A way to find if a transaction is allready running?

Can I find if a transaction is allready initiated?

Ex:
 In a hight level language I begin a transaction ...

PSEUDO-CODE
 BeginTransaction(sqlHandler);

     ExecuteQuery('Update .....',  sqlHandler);
     ExecProc('package.InsertHeader(iId)', sqlHandler);

Commit(sqlHandler);

PL/SQL
Create or Replace Package

InsertHeader(iId integer)
begin

• Transaction not allready running ? if not TRANSACTION RUNNING (How can I do this?) then set transaction read write; end if;

    Insert into table
     (...)
    values
    (...)

   if not TRANSACTION RUNNING (??) then

        commit
  end if;

end; Received on Thu Dec 14 2000 - 06:32:32 CST