Hi Marco,

When I try to insert a big varchar2 (with 4000 characters) I'm getting an error: "ORA-01480: trailing null missing from STR bind value".

Could you please try the following:

1 - create table test (a varchar2(4000));
2 - select lpad('A',,'A') from dual;
3 - Open the result of the query with large data editor and copy the content
4 - Edit data of table test and paste the result of the query into the table.
5- When I try to post changes, I get the error "ORA-01480: trailing null missing from STR bind value".

If I use an insert statment, everything works ok:
insert into test
select lpad('A',4000,'A') from dual;


Thanks in advance.

Last edited by mamv; 07/19/10 01:49 PM.