Re: Problem with rollback

Wasim wrote:
> 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.

As Daniel mentioned, please post the real code. However from this pseudocode I have to ask: Why do you have the "when others" clauses in the two inner blocks? They seem to serve no purpose.

-- 
Edward J. Prochak   --- Magic Interface, Ltd.
Ofc: 440-498-3700   --- 7295 Popham Place, Solon, OH 44139
on the web at       --- http://www.magicinterface.com
email: ed.prochak_at_magicinterface.com