Problem with rollback

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 it not rolling back the informaton that is put in the tables. I don't know any reason why its doing that becasue the out block should rollback.

Regards,
Wasim. Received on Wed Nov 13 2002 - 12:21:19 CST