Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: psql commit
Autonomous transactions might be what you are looking for ...
tony wrote:
> I would like to know when exactly the implied commit takes place in a
> plsql block.
>
> for example:
>
> BEGIN
>
> if flag is 'Y'
> update table a set ......
> end if
>
> send email to someone yada, yada...
> do some html stuff...
>
> END
>
> I'm wondering if I can be sure the commit takes without explicitly
> coding it if something goes wrong after the sql part but before the
> END.
Received on Sun Mar 05 2006 - 14:27:08 CST