Page 1 of 1
Array Binding Error
Posted: Mon 03 Feb 2014 18:07
by Partizan
Hi guys,
I'm trying to utilize Array Binding to perform bulk insert.
However, I'm using array of OracleTable instances to send to SP (my SP accepts one varchar2 and one ... Table of ... argument).
As A result, I got ORA-03106: fatal two-task communication protocol error.
While it's completely ok if I don't use array binding and send those one by one.
Do you have any ideas on this?
Re: Array Binding Error
Posted: Mon 03 Feb 2014 18:13
by Partizan
Strangely enough, exception occurs only if array length is more than 2.
Re: Array Binding Error
Posted: Mon 03 Feb 2014 18:47
by Partizan
Tried on the latest 8.2 trial - still the same.
Re: Array Binding Error
Posted: Thu 06 Feb 2014 16:27
by Pinturiccio
We have reproduced the issue in the Direct mode. We will investigate it and post here about the results as soon as possible.
Re: Array Binding Error
Posted: Fri 07 Feb 2014 08:49
by Partizan
Thank you. Looking forward to getting this fixed.
Re: Array Binding Error
Posted: Tue 11 Feb 2014 12:03
by Partizan
Hi, A little addition here:
I tried to execute the same using arrays of length 2.
First time it is executed successfully, but on a second set of arrays I get:
ORA-03113: end-of-file on communication channel
The problem doesn't appear when the arrays are of length 1.
Alex.
Re: Array Binding Error
Posted: Tue 11 Feb 2014 14:12
by Pinturiccio
Thank you for the additional information, we will consider it when researching the issue.
Re: Array Binding Error
Posted: Thu 13 Feb 2014 14:57
by Partizan
Not sure if that helps, but just in case, the same behavior is on typical INSERT statements with array binding.
Re: Array Binding Error
Posted: Mon 28 Apr 2014 13:48
by drzewieckil
Hello,
I have exactly the same problem. I can't bulk insert more than one row with ExecuteArray.
Do you know anything more about this problem?
Re: Array Binding Error
Posted: Tue 29 Apr 2014 14:43
by Pinturiccio
Our investigation came to the conclusion that it's impossible to use Objects with array binding feature in Direct mode. Other ADO.NET providers also don't support this feature.
If we find a possibility to implement it, we will post the message here.
Re: Array Binding Error
Posted: Wed 30 Apr 2014 05:45
by drzewieckil
That's too bad.
I work in linux (MONO), so I have to use Direct mode because Oracle Client doesn't work in linux.
BTW - When I use oracle client in Windows (not Direct mode) everything is working perfectry well whith Array Bindings.
Re: Array Binding Error
Posted: Wed 04 May 2016 08:55
by Pinturiccio
We have supported Oracle objects in array binding in the Direct mode.
We have improved the implementation of DML arrays in output parameters in the Direct mode.
We will post here when the corresponding build of dotConnect for Oracle is available for download.
Re: Array Binding Error
Posted: Fri 06 May 2016 08:47
by Pinturiccio
New build of dotConnect for Oracle 9.0.12 is available for download!
It can be downloaded from
http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to
http://forums.devart.com/viewtopic.php?t=33635