Re: how to code a transaction.

i676373_at_gmail.com wrote:
> i,
>
> How do I manually code an atomic transaction, given the following
> scenario?
>
> 1. User need to pay a fine.
> 2. User log into the system.
> 3. User click the pay button.
> 4. User pay by a custom payment methods called NETS (system operated
> through telephone line, in Singapore; it is not direct connection to a
> databse, but somekind of services.)
> 5. Payment/NETS transaction done; transaction cannot rollback after
> this.
> 6. System would update the database to indicate the fine have been
> paid.
>
> But step 6 might fail. How do I ensure that all the steps is in
> one single transaction?
> Is there any example/web page which show how to program a atomic
> transaction manually?
>
> Thanks
>
> regards,
> john.

Don't perform incremental commits.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org