Rollback problem, please help

Hello,

I am having strange problem with rollback statement. My code looks like this

Begin

    insert into some tables;
    Begin

        get a value from database;
    exception when no_data_found

        handle it;
    when others

        raise;
    end
    do some other stuff
    begin

        do some updates;
    exception when no_data_found

        handle it;
    when others
    then

       raise;
    end;
    commit;
exception when others
  rollback;
  raise
end;         

When an exception occurs its not rolling back the transaction (the information put in tables is still there). I don't know any reason why its doing that because the outer block should rollback the transaction.

Regards,
Wasim. Received on Wed Nov 13 2002 - 12:26:18 CST