Large Data Editor Problem - 07/19/10 01:49 PM
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.
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.