NLS_LENGTH_SEMANTICS

How to Resolve ORA-28232: invalid input length for obfuscation toolkit

by Ed Chen
July 17, 2021June 4, 2022

ORA-28232 Developers tried to obfuscate data by DBMS_OBFUSCATION_TOOLKIT in a database with multi-byte character set and got this error. ORA-28232: invalid input length for obfuscation… Read More »

How to Set NLS_LENGTH_SEMANTICS Temporarily

by Ed Chen
May 19, 2021December 17, 2021

NLS_LENGTH_SEMANTICS Let's see what NLS_LENGTH_SEMANTICS of the database currently set. SQL> conn hr/hr@orclpdb Connected. SQL> show parameter semantics; NAME … Read More »

How to Resolve ORA-12899: value too large for column

by Ed Chen
November 13, 2019December 10, 2022

ORA-12899 ORA-12899 means that the value of being inserted or updated data is larger than column's allowable length that is defined in the table. What… Read More »

BYTE vs CHAR in NLS_LENGTH_SEMANTICS

by Ed Chen
December 12, 2012March 21, 2023

BYTE vs CHAR in NLS_LENGTH_SEMANTICS Most of databases set NLS_LENGTH_SEMANTICS as BYTE by default, but there are some databases in Non-English country will take CHAR… Read More »