Kbase P122478: Error 12766 occurs when temp-table parameters are used for temp-tables defined LIKE database tables
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/19/2010 |
|
Status: Verified
SYMPTOM(s):
Running procedure on AppServer
AppServer procedure receives temp-table as INPUT TABLE-HANDLE parameter
AppServer procedure calls second procedure
Called procedure defines static temp-table parameter
Passing dynamic temp-table by-reference
Static temp-table is defined LIKE a database table
Static temp-table is defined REFERENCE-ONLY
Database table referred to in LIKE definition has had fields dropped and/or field order changed
<program-name> Cannot bind BY-REFERENCE parameter tables or datasets unless column datatypes, positions, extents and indexes match for tables <name> and <name>. (12766)
FACT(s) (Environment):
OpenEdge 10.1x
All Supported Operating Systems
OpenEdge Category: Language (4GL/ABL)
CAUSE:
Bug# OE00146463
FIX:
Upgrade to OpenEdge 10.1B01 or later release
Workaround:
Do not define temp-tables LIKE database tables
Instead, define the individual temp-table fields LIKE the matching database fields or avoid the LIKE definitions altogether (for example by using a code generator that creates field definitions of the appropriate datatypes etc. based on the database schema).