Kbase P17440: Error 132 using a Temp-table copying data reading from a Oracle table
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/6/2009 |
|
Status: Unverified
SYMPTOM(s):
Error 132 using a Temp-table copying data reading from a Oracle table
** <file-name> already exists with <field/value...>. (132)
No Error 132 when added records using accentuation in a Oracle table
DataServer allows create records with a unique key field where the only difference is using accentuation like "pais" and "país".
FACT(s) (Environment):
All Supported Operating Systems
Oracle DataServer
CAUSE:
This is an expected behavior. ORACLE, by Default, uses BINARY Collation table and Progress uses BASIC table. Collation tables are used for sorting and character comparison. Using BASIC does not distinguish between special characters and letters as opposed to Binary collation table.
FIX:
Change ORACLE collation table from BINARY to ASC using NLS_SORT settings. It is highly recommended that you call Oracle Technical Support to verify the requirements and execute the appropriate changes. Unappropriate changes may result on Data Corruption.