Consultor Eletrônico



Kbase P12625: oracle stored procedure does not return anything
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   3/20/2003
Status: Unverified

FACT(s) (Environment):

Progress 9.1A05

FACT(s) (Environment):

Oracle DataServer

SYMPTOM(s):

Oracle stored procedure does not run correctly

Stored procedure works when using Oracle DataServer Progress 8.x

CHANGE:

Migrated from Progress 8.3A to 9.1A05

CAUSE:

Bug# 20000524-015

CAUSE:

It appears for output parameters, ORACLE is setting *plen AND *perr both to the current length of the value returned. Dataserver treats nonzero *perr as error code.

FIX:

The issue has been fixed in Progress 9.1A05 Patch and Progress 9.1B.

LINUX Intel 9.1A07
Compaq Tru64 UNIX 9.1A09
SUN SOLARIS INTEL 9.1A09
HP/UX 11 9.1A10
UNIX V.4 9.1A10
IBM AIX 9.1A11
WIN NT 32 Intel 9.1A14