Consultor Eletrônico



Kbase P140600: Error-status Does Not Capture Error Occurred During Oracle Stored Procedure Execution
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   15/03/2010
Status: Verified

SYMPTOM(s):

Error-status does not capture error occurred during Oracle stored procedure execution

proc-status does not return the error coded in raise_application_error in stored procedure

FACT(s) (Environment):

All Supported Operating Systems
Oracle DataServer

CAUSE:

Bug # OE00180512

FIX:

The workaround is to use an output parameter in Oracle stored procedure that catches Oracle exceptions and passes it to 4GL