ORA-01480: trailing null missing from STR bind value

I got ” ORA-01480: trailing null missing from STR bind value ”  error in Oracle database.

ORA-01480: trailing null missing from STR bind value

Details of error are as follows.

ORA-01480: trailing null missing from STR bind value


Cause: A bind variable of type 5 (null-terminated string) does not contain the terminating 
null in its buffer.

Action: Terminate the string with a null character Oracle MOSC documentation gives a 
description of ORA-001480 which portrays it much like a bug with certain versions of Oracle.

trailing null missing from STR bind value

This ORA-01480 error is related with the bind variable of type 5 (null-terminated string) does not contain the terminating null in its buffer.

Terminate the string with a null character Oracle MOSC documentation gives a description of ORA-001480 which portrays it much like a bug with certain versions of Oracle.

If you use the SQL Loader, you should check the table name in the control file, if you use table name with > 30 characters, you will get this error.

Check and fix it.

Do you want to learn Oracle Database for Beginners, then read the following articles.

Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )