Kbase P12749: Record was changed using Oracle DataServer, however change did not commit within ORACLE
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Verified
FACT(s) (Environment):
Oracle DataServer
SYMPTOM(s):
Record was changed using Oracle DataServer, however change did not commit within ORACLE
Record changed using WRITE trigger
CAUSE:
Record creation and update behavior differs between Progress and ORACLE when going through the Oracle DataServer. ORACLE DataServer writes the record later than Progress does, it writes it at the end of the record scope.
When using CREATE/WRITE triggers, the triggers need to completed in order for the record to be written to the database.
FIX:
Use a VALIDATE statement causes the DataServer to write the record to the database immediately.