Kbase P158540: Mismatch errors with OUTPUT TABLE-HANDLE parameters
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
13/01/2010 |
|
Status: Unverified
SYMPTOM(s):
Mismatch errors with OUTPUT TABLE-HANDLE parameters
Parameter number (table <table name>) mismatch. Has <field#> fields - client schema has <fields#> fields. (8030)
The caller's temp-table parameter does not match to the target temp-table . (5363)
Try switching TEMP-TABLE method ADD-FIELDS-FROM for CREATE-LIKE. (9030)
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.2A
CAUSE:
When the AVM passes a table or table-handle through an output parameter it detects whether the receiving side variable exists already and attempts to save resources by only copying the data into the existing schema.
The receiving handle could be for a static temp-table so instead of trying to destroy it the schema is checked to see if it matches then the data are copied back if so.
FIX:
If the temp-table the handle points to prior to the call will be re-used and deleted later then store it off in a different variable and assign it the unknown value (?). If you are finished with the temp-table delete it before the call is made in order to ensure that there is no memory leak.