It's a good idea. However, it's not that easy as with ORA_MAX_NAME_LEN, because you would need to recompile all PL/SQL code after changing to EXTENDED. - A package holding the constant would be good enough. Change the value manually or by a generator would enforce recompilation of the affected code.

Comments