Kbase P90559: Error passing input temp-table handle parameter to AppServer with BLOB field
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/28/2004 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.0A
SYMPTOM(s):
Passing the temp-table handle as input parameter to the called procedure on AppServer fails with error:
Maximum size for BLOB in field <garbled string> is 0. Attempted <integer number>.
The temp-table contains field of BLOB data type.
Same RUN statement works fine when called procedure is executed in the same session i.e. without AppServer.
10.A01
CAUSE:
This is a known issue being investigated by Development
FIX:
Replace the temp-table handle input parameter with INPUT TABLE parameter.
Instead of:
RUN remote_proc ON hAS (TABLE-HANDLE hTempTable) .
use:
RUN remote_proc ON hAS (INPUT TABLE TempTable) .
The definition of the 'TempTable' temp-table needs to be added to the
procedure 'remote_proc' and the definition of the input parameter changed accordingly.