Ora-28232

ORA-28232: invalid input length for obfuscation toolkit
ORA-06512: at "SYS.DBMS_OBFUSCATION_TOOLKIT_FFI", line 0
ORA-06512: at "SYS.DBMS_OBFUSCATION_TOOLKIT", line 153


Select on an Imported table gives Ora-28232 [ID 308722.1]

While exporting the table, NLS_LANG was set to US7ASCII whereas the DB characterset of both the databases are UTF8
This caused wrong characterset conversions between multibyte UTF8 and singlebyte US7ASCII

DB characterset of both the databases are UTF8 but exporting session has NLS_LANG set to US7ASCII. This caused improper characterset conversions between multibyte UTF8 and singlebyte US7ASCII  causing wrong length of data in the imported table thus leading to error Ora-28232.
Length of the data in the table column before export and after import can be verified/checked using the dump function
eg: select  ... , dump(col_name)  from table_name;

Solution

While exporting please set the NLS_LANG to UTF8 and also ensure the same is set to UTF8 during the import.
Eg:
NLS_LANG = AMERICAN_AMERICA.UTF8