Kbase P16942: Error 1478 and oracle error -11041 updating fields via 4GL
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Verified
FACT(s) (Environment):
Oracle DataServer
SYMPTOM(s):
Error 1478 and oracle error -11041 updating fields via 4GL using share-lock
SYSTEM ERROR: ORACLE Rollback err <code> (1478)
SYSTEM ERROR: ORACLE Rollback err -11041 (1478)
The same update can be executed using a SQL UPDATE statement from a non Progress Oracle client
CAUSE:
The implementation for the DataServer reads and update records in a different way than SQL application does. There are some types of updates that will perform an update more efficiently using SQL updates instead of using 4GL updates.
FIX:
Use Send-Sql-Statements. See Progress Solution P16940, What is a send-sql-statement ?