Kbase P152725: LOAD-RESULT-INTO statement does not accept dynamic array of table
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/02/2010 |
|
Status: Unverified
SYMPTOM(s):
LOAD-RESULT-INTO statement does not accept dynamic array of table
Only <> handles supplied but there are at least <> result-sets (12209)
Only -32767 handles supplied but there are at least 0 result-sets (12209)
FACT(s) (Environment):
Using dynamic array of table with the LOAD-RESULT-INTO statement
All Supported Operating Systems
OpenEdge 10.x
CAUSE:
Bug# OE00190838
FIX:
Upgrade to OpenEdge 10.2B or higher release
or,
use the following workaround: case numTables:
when 01 then do:
define variable array01 as handle extent 01
no-undo.
array01[1] = tables[1].
run stored-proc send-sql-statement
load-result-into array01 no-error ( sqlQuery ).
end.
when 02 then do:
define variable array02 as handle extent 02
no-undo.
do i = 1 to 02:
array02[i] = tables[i].
end.
run stored-proc send-sql-statement
load-result-into array02 no-error ( sqlQuery ).
end.
. . .
end case.