Re: how to code a transaction.

On Mar 5, 8:30 pm, i676..._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.

The transaction management in Oracle databases is very well described in "Transaction Management" chapter of the Concepts doc: http://download-east.oracle.com/docs/cd/B14117_01/server.101/b10743/transact.htm#i6564.

Valentin Received on Tue Mar 06 2007 - 06:04:08 CST