Array Binding Error

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
Partizan
Posts: 36
Joined: Fri 13 Nov 2009 10:18

Array Binding Error

Post by Partizan » Mon 03 Feb 2014 18:07

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?

Partizan
Posts: 36
Joined: Fri 13 Nov 2009 10:18

Re: Array Binding Error

Post by Partizan » Mon 03 Feb 2014 18:13

Strangely enough, exception occurs only if array length is more than 2.

Partizan
Posts: 36
Joined: Fri 13 Nov 2009 10:18

Re: Array Binding Error

Post by Partizan » Mon 03 Feb 2014 18:47

Tried on the latest 8.2 trial - still the same.

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: Array Binding Error

Post by Pinturiccio » Thu 06 Feb 2014 16:27

We have reproduced the issue in the Direct mode. We will investigate it and post here about the results as soon as possible.

Partizan
Posts: 36
Joined: Fri 13 Nov 2009 10:18

Re: Array Binding Error

Post by Partizan » Fri 07 Feb 2014 08:49

Thank you. Looking forward to getting this fixed.

Partizan
Posts: 36
Joined: Fri 13 Nov 2009 10:18

Re: Array Binding Error

Post by Partizan » Tue 11 Feb 2014 12:03

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.

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: Array Binding Error

Post by Pinturiccio » Tue 11 Feb 2014 14:12

Thank you for the additional information, we will consider it when researching the issue.

Partizan
Posts: 36
Joined: Fri 13 Nov 2009 10:18

Re: Array Binding Error

Post by Partizan » Thu 13 Feb 2014 14:57

Not sure if that helps, but just in case, the same behavior is on typical INSERT statements with array binding.

drzewieckil
Posts: 4
Joined: Mon 28 Apr 2014 11:33

Re: Array Binding Error

Post by drzewieckil » Mon 28 Apr 2014 13:48

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?

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: Array Binding Error

Post by Pinturiccio » Tue 29 Apr 2014 14:43

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.

drzewieckil
Posts: 4
Joined: Mon 28 Apr 2014 11:33

Re: Array Binding Error

Post by drzewieckil » Wed 30 Apr 2014 05:45

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.

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: Array Binding Error

Post by Pinturiccio » Wed 04 May 2016 08:55

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.

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: Array Binding Error

Post by Pinturiccio » Fri 06 May 2016 08:47

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

Post Reply