Re: psql commit

From: tony <bigtoehere_at_hotmail.com>
Date: Mon, 06 Mar 2006 10:09:42 -0400
Message-ID: <bfgo029mrb7fuun0q7blf5i259vhb531r9@4ax.com>

On Fri, 03 Mar 2006 12:34:22 -0800, DA Morgan <damorgan_at_psoug.org> wrote:

>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.

This is in a plsql program executed over the internet. The update, as coded above, *is* commited under normal circumstances. I am searching for possible reasons that the commit may not happen. Received on Mon Mar 06 2006 - 08:09:42 CST