Error in Execute array
Posted: Mon 05 Jun 2006 22:19
Please solve my problem.
I'm trying to select data from a table and to insert those into another table.
As a first approach I used dataloader and it works fine. However it holds lock on the target table and disables all the indexed on that table.
So I used execute array method but I faced two problem.
One is if it encouter certain string like " '번호' work_no", it stops with an error - ORA-01480: trailing null missing from STR bind value.
If I insert that data from a textbox, there's no error. However if I insert data after selecting from a table, there's an error.
I have spent two days trying to slove this problem, even though I'm working on a tight schedule. To solve this problem is one of the key factor to success my project.
The other is it uses huge amount of client memory than dataloader.
I'm using oracle 9i and oradirect .net 3.5 for .net framework1.1 and current chacterset is KO16KSC5601.
Thanks in advance.
I'm trying to select data from a table and to insert those into another table.
As a first approach I used dataloader and it works fine. However it holds lock on the target table and disables all the indexed on that table.
So I used execute array method but I faced two problem.
One is if it encouter certain string like " '번호' work_no", it stops with an error - ORA-01480: trailing null missing from STR bind value.
If I insert that data from a textbox, there's no error. However if I insert data after selecting from a table, there's an error.
I have spent two days trying to slove this problem, even though I'm working on a tight schedule. To solve this problem is one of the key factor to success my project.
The other is it uses huge amount of client memory than dataloader.
I'm using oracle 9i and oradirect .net 3.5 for .net framework1.1 and current chacterset is KO16KSC5601.
Thanks in advance.