Skip to content
September 11, 2012 / doganay

ORA-01480: trailing null missing from STR bind value


Problem:

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.


Solution:

Terminate the string with a null character.

* Use chr(0) instead of ''
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: