Consultor Eletrônico



Kbase P126791: Instantiation of Database trigger code takes longer time with Oracle DataServer than Progress/400 Da
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   12/11/2007
Status: Unverified

FACT(s) (Environment):

Progress/OpenEdge Versions
Oracle DataServer

SYMPTOM(s):

Instantiation of Database trigger code takes longer time with Oracle DataServer than Progress/400 DataServer

Loading of Database trigger code takes longer time with Oracle DataServer than Progress/400 DataServer

Instantiation of Database trigger code takes 10x longer time with Oracle DataServer than Progress/400 DataServer

Loading of Database trigger code takes 10x longer time with Oracle DataServer than Progress/400 DataServer

CAUSE:

Using the search function with etime for .r (DB trigger code) reveals that the .r is not found, but the related .p is found. The Database trigger code is not compiled for Oracle DataServer environment whereas the trigger code is compiled on Progress/400 environment.

FIX:

Compile the Database trigger code in Oracle DataServer environment