Kbase 19845: Error 10 When Using Oracle's Delete Trigger
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
24/09/2008 |
|
Status: Verified
FACT(s) (Environment):
Oracle DataServer
SYMPTOM(s):
SYSTEM ERROR: bfdel: rmdel failed. (10)
Error when a DELETE trigger raises an exception or rollback command.
Error when attempting to delete a record via Progress application
CAUSE:
Dataserver Oracle does not expect to receive an error from any Oracle trigger. This error will be treated as a fatal error for the application.
FIX:
Define a delete trigger in the schema holder to avoid firing Oracle's trigger in order to avoid the exception. Also, make use of stored-procedures or send-sql-statement feature to implement any specific code that needs to be executed under Oracle.