ORA-01480: trailing null missing from STR bind value tips

The Oracle docs note this on the ORA-01480 error:

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:

 

Problem Description: Attempt to load data into a table with a name more than 30 characters will result in misleading error messages to users of SQL*Loader on the OpenVMS platform.

Simply create a control file (e.g. TEST.CTL) as follows:

LOAD DATA
Infile *
INTO TABLE Thisisaverylongtablenamewhichcannottexist
(col1)
begindata
1111

at the command line :-

SQLLOADER username/password CONTROL=TEST.CTL


Each version produces an ORA-1480 error (see Note 18882.1)

However, the resulting combination of errors varies with different versions of Oracle running on OpenVMS:-


Solution Description:

Correct the table name in the control file as it is not possible to have a table name with > 30 characters in current versions of Oracle.

Explanation:

Its likely that the user has mistyped an already long table name and the spurious characters have taken the name over 30 characters.