SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PlSQL ERROR (ORA-01480:trailing null missing from STR bind value)

39cf3dff-9b66-492a-a639-69718a1d216aMar 3 2016 — edited Mar 4 2016

In a Procedure, gave input string as varchar2, so now while passing the string for debugging there is an error

ORA-01480: trailing null missing from STR bind value

How to rectify this issue.

the string which i pass is similarly like this D00900061#31/Mar/2014#D009#10#12500000#12500000#ST#0.4#5000000#INFAPP@C01400004#30/Jun/2014#C014#150#68700000#50001000#ST#0.4#20000400#

and also string contains 2714 characters

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 1 2016

Added on Mar 3 2016

6 comments

3,852 views