Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: psql commit
tony wrote:
> Thanks for the replies. The subject should say plsql....it was the
> end of a long day ; ) I'll try to explain my question more fully.
>
> BEGIN
> IF X = '1' THEN
> UPDATE mytable
> SET myfield = 1
> WHERE id=idIn;
>
> htp.print('Thank you!);
> ELSE
> htp.print('Operation failed')
> END IF;
> END
>
> Does the commit occur after the WHERE clause or not until END?
>
> thanks again,
> tony
For the update statement above ... no commit ever takes place.
-- Daniel A. Morgan http://www.psoug.org damorgan_at_x.washington.edu (replace x with u to respond)Received on Fri Mar 03 2006 - 14:34:22 CST