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.
Error in Execute array
I forgot to mention that data was stored in a long column.
I forgot to mention that data was stored in a long column.