Kbase P2978: How oracle commit transaction
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
24/01/2005 |
|
Status: Unverified
GOAL:
How to commit a record into an Oracle database.
FACT(s) (Environment):
Oracle DataServer
Oracle
FIX:
A new record is created into an Oracle database at the end of the transaction.
To make available a new record in the same session, use the VALIDATE statement after assigning all the required fields.
CREATE customer.
ASSIGN cust-num = 1
name = "Progress".
VALIDATE customer.
This does flush to disk the record allowing to access this 'newly' created record from the same session.