Sunday, April 20, 2008

ORA-01480: trailing null missing from STR bind value

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

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

The column that is being read has a value which is too large to fit into the variable in the C program if a SELECT, or, the string contains a longer value than the column can support if it is an INSERT or UPDATE statement.

No comments: