Kbase 19844: Error 4570: When Running Oracle 7.x Stored-Procedure
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
14/06/2002 |
|
Status: Unverified
FACT(s) (Environment):
Oracle 7.x
Progress 8.3C
Progress 9.0B
Progress 9.1A
SYMPTOM(s):
orafldx: file number mismatch icb: <file number> ci: <file number> (4570)
CAUSE:
In Progress, when an Oracle 7.x function is run, that does not have an input/output parameter in it, error 4570 is encountered. Without an input/output parameter, Oracle DataServer passes the parentheses as follows:
begin :Z1 := USER1.MYFUNC(); end;
Without an input/output parameter, ORACLE 7.x does not allow parentheses. This is not a problem for orcle 8.x, as this version allows parentheses with no parameter specified.
FIX:
Upgrade to latest patch levels on Progress 8.3C, Progress 9.0B, Progress 9.1A