Oracle name length limits

Posts   
 
    
tomcap
User
Posts: 15
Joined: 03-Apr-2017
# Posted on: 22-Oct-2021 20:35:53   

LLBLGen 5.8.1; Database First, Adapter

As of Oracle 12.2 names in Oracle can exceed 30 characters (limit is now 128); http://docs.oracle.com/database/122/SQLRF/Database-Object-Names-and-Qualifiers.htm#SQLRF51129

When the LLBLGen Oracle DQE generates queries, it is hashing the field names if their length exceeds 30 characters: https://www.llblgen.com/Documentation/5.6/LLBLGen%20Pro%20RTF/whatsnew.htm - "see Better name length clamping in DB2 and Oracle DQEs" section

Is there a way to prevent the hashing/clamping?

Out of curiosity, what was the purpose of hashing/clamping since this resulted in a query that did not actually work?

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39614
Joined: 17-Aug-2003
# Posted on: 23-Oct-2021 10:20:41   

That is due to a bug, it was fixed in 5.8.2:

Fix Runtime Libraries 5.8 5.8.2 18-May-2021 Oracle: A fixed made to v5.7.4 and 5.8.1 regarding name clamping caused an issue in edge cases when aliases were longer than 30 characters and targeting aliased fields also with names which were longer than 30 characters

https://www.llblgen.com/Pages/ChangelogBrowser.aspx

Frans Bouma | Lead developer LLBLGen Pro