Kbase P120658: Error 5363 and 12311 when passing a temp table as a parameter
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/22/2006 |
|
Status: Unverified
SYMPTOM(s):
Error 5363 and 12311 when passing a temp table as a parameter
The caller's temp-table parameter does not match to the target temp-table . (5363)
The caller's temp-table parameter TT-FE does not match to the target temp-table TT-FE. (5363)
Parameters for procedure <procedure name> (table <TTname> and table <TTname>) do not match. (12311)
In the calling program the temp table is defined with DEFINE TEMP-TABLE.
In the called program the temp table is defined LIKE A database table.
CAUSE:
The order of the fields defined in the calling program with DEFINE TEMP-TABLE must be the same as the order defined in the database for the two temp table definitions to match.
FIX:
To resolve this problem do the following:
1. Begin by generating and include file based on the DEFINE-WORK table statement, from the Data Administration tool (Utilities->Generate Include Files->DEFINE WORK-TABLE statement).
2. Paste the generated include file code into the calling procedure and modify the DEFINE WORK-TABLE statement so that it is DEFINE TEMP-TABLE.
3. Dump a .df file of the table and order the fields in the DEFINE TEMP-TABLE statement in the sequence they are defined in the .df file.
The code should now work without error.