Array Binding Error

Array Binding Error

Postby 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

Postby 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

Postby Partizan » Mon 03 Feb 2014 18:47

Tried on the latest 8.2 trial - still the same.
Partizan
 
Posts: 36
Joined: Fri 13 Nov 2009 10:18

Re: Array Binding Error

Postby 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.
Pinturiccio
Devart Team
 
Posts: 1869
Joined: Wed 02 Nov 2011 09:44

Re: Array Binding Error

Postby 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

Postby 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.
Partizan
 
Posts: 36
Joined: Fri 13 Nov 2009 10:18

Re: Array Binding Error

Postby Pinturiccio » Tue 11 Feb 2014 14:12

Thank you for the additional information, we will consider it when researching the issue.
Pinturiccio
Devart Team
 
Posts: 1869
Joined: Wed 02 Nov 2011 09:44

Re: Array Binding Error

Postby 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.
Partizan
 
Posts: 36
Joined: Fri 13 Nov 2009 10:18

Re: Array Binding Error

Postby 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?
drzewieckil
 
Posts: 4
Joined: Mon 28 Apr 2014 11:33

Re: Array Binding Error

Postby 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.
Pinturiccio
Devart Team
 
Posts: 1869
Joined: Wed 02 Nov 2011 09:44

Re: Array Binding Error

Postby 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.
drzewieckil
 
Posts: 4
Joined: Mon 28 Apr 2014 11:33

Re: Array Binding Error

Postby 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: 1869
Joined: Wed 02 Nov 2011 09:44

Re: Array Binding Error

Postby 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
Pinturiccio
Devart Team
 
Posts: 1869
Joined: Wed 02 Nov 2011 09:44


Return to dotConnect for Oracle