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.

Is any of that "do some stuff" DDL?

If not post all of the code as there is no other explanation I can see from what you have posted.

Daniel Morgan Received on Wed Nov 13 2002 - 14:16:52 CST