Kbase P73963: Oracle DataServer: NO-ERROR on run stored-procedure rejects by syntax checker
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
08/12/2006 |
|
Status: Unverified
SYMPTOM(s):
Oracle DataServer: NO-ERROR on run stored-procedure rejects by syntax checker
Run Stored-PROC does not compile when "NO-ERROR" is place after the input or output parameters
Run Stored-PROC compiles when "NO-ERROR" is place after the [integer = PROC-HANDLE] and before the the input or output parameters
CAUSE:
BUG # 20040326-008
CAUSE:
The syntax presented in the Version 9.1x Progress DataServer Oracle guide was incorrect. The "NO-ERROR" is supposed to be coded before the input outpot parameters.
FIX:
The syntax was corrected on the OpenEdge DataServer for Oracle guide.
The following is the correct syntax:
RUN STORED-PROCEDURE procedure-name
[[LOAD-RESULT-INTO <handle> [<int> = PROC-STATUS]]|
[<int> = PROC-HANDLE]]
[ NO-ERROR ]
[([INPUT|OUTPUT|INPUT OUTPUT] [PARAM parameter-name =]expression, ...
[INPUT|OUTPUT|INPUT OUTPUT] [PARAM parameter-name =]expression )]