Array Binding Error
Array Binding Error
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?
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
Strangely enough, exception occurs only if array length is more than 2.
Re: Array Binding Error
Tried on the latest 8.2 trial - still the same.
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Array Binding Error
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
Thank you. Looking forward to getting this fixed.
Re: Array Binding Error
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.
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.
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Array Binding Error
Thank you for the additional information, we will consider it when researching the issue.
Re: Array Binding Error
Not sure if that helps, but just in case, the same behavior is on typical INSERT statements with array binding.
-
- Posts: 4
- Joined: Mon 28 Apr 2014 11:33
Re: Array Binding Error
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?
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?
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Array Binding Error
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.
If we find a possibility to implement it, we will post the message here.
-
- Posts: 4
- Joined: Mon 28 Apr 2014 11:33
Re: Array Binding Error
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.
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.
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Array Binding Error
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.
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.
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Array Binding Error
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
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