ORA-01480: trailing null missing from STR bind value

[Former Member]

Hi Everyone,

I´m having the following error when running a job where stage tables are in ORACLE.

ORA-01480: trailing null missing from STR bind value

The DS environment is conformed by ORACLE as repository and stage layer database, Job Server installed in AIX.

This occurs when inserting to a target table.

Any ideas?

Kind regards,

Christian

[Former Member]

Hi, Christian.

The error description:

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

Maybe you're trying to insert a string in a column that is bigger than the column length. So, the terminating character is not being inserted at the end of the string.

You can insert a breakpoint right before the target table and execute the job in debug mode to verify what is being passed to the target table.

I hope it helps.

Leonardo.

[Former Member]

Is this happening for all records or to some specific records? can you just filter the data using a where condition and execute it? If you can identify a row which fails beacuse of this error, then try concatenating chr(10) to all varchar2 fileds in the column mappings and then execute the job with the failed record.

Regards,

Shine