Nested Transaction Level

I have a stored procedure which call another stored procedure,like this:

procedure SP_AAA is
begin

    savepoint savepoint1;
    exec a sql_statement;
    SP_BBB;
    commit;
exception

    when others then
    rollback to savepoint1;
end;

procedure SP_BBB is
begin

    exec a sql_statement;
    commit;
end;

and the result is you could not rollback to savepoint1 in SP_AAA because you have commited in SP_BBB.

I would like to know in which level of nested transaction I am, so I can decide to commit or not.
How to do so? Any suggestion?

thanks a lot,

    _-^-_nto Received on Thu Mar 08 2001 - 11:44:31 CST