Error in Execute array

Error in Execute array

Postby Ji » 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 forgot to mention that data was stored in a long column.

Postby ji » Mon 05 Jun 2006 22:35

I forgot to mention that data was stored in a long column.

Postby Alexey » Tue 06 Jun 2006 12:09

disables all the indexed

It is an Oracle Direct Path loading behaviour.
Try to use Unicode=true in the ConnectionString, otherwise you need client charset KO16KSC5601 and Regional Setting in Windows compertible with this charset.
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Return to dotConnect for Oracle