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.
What implied commit? This is Oracle. There is no such thing.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Thu Mar 02 2006 - 15:06:18 CST
