CHAR

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-00932: inconsistent datatypes: expected CHAR got LONG

by Ed Chen
November 28, 2020October 24, 2021

ORA-00932 ORA-00932 means that SQL engine wanted to retrieve CHAR strings, but it saw LONG data type, which is unsearchable. So SQL engine refused to… Read More »