Kbase P118096: Error 1410 when a procedure return a dataset handle and uses dynamic dataset with static temp-table
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/7/2007 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.1A
SYMPTOM(s):
Error 1410 when a procedure returns a dataset handle as output parameter
error code -20011 returned from fdfnd (1410)
Procedure creates internally a dynamic dataset and after it returns it
Dataset uses static temp-table as member tables
CAUSE:
Bug# OE00131412
FIX:
Upgrade to OpenEdge 10.1B or later release.
Workaround:
Use a static DATASET in the called routine, just like its member tables and return the handle using: datasetHandle = DATASET mydataset:HANDLE.
Static temp table are released from the memory after the scope of the routine. Therefore the Dataset cannot live beyond the end of the routine anyway, because its tables will be invalid at that point, and so it makes sense to define it as a static dataset.