Kbase P154667: Passing SHARED temp-table as parameter with BY-REFERENCE results in error
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/22/2010 |
|
Status: Unverified
SYMPTOM(s):
Passing SHARED temp-table as parameter with BY-REFERENCE results in error
<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):
Sun Solaris SPARC 32-bit
This worked in 10.1B
OpenEdge 10.1C
OpenEdge 10.2A
CAUSE:
Bug# OE00192593
FIX:
Upgrade to OpenEdge release 10.2A03 or later
FIX:
To workaround this behavior do one of the following:
- Remove the SHARED status from the source temp-table definition
This would likely require work in existing code to remove shared references to the table and pass it as a parameter everywhere it is currently shared.
or...
- Make it SHARED in both the caller and callee and don't pass the temp-table as a parameter
This would be easiest since you're not changing the nature of the source temp-table
or...
- Pass the temp-table BY-VALUE rather than BY-REFERENCE
This has performance implications but would require the smallest code change