Calling Procedure with ref cursor param via LinqConnect

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
killpapa
Posts: 19
Joined: Sun 29 Jan 2012 16:12

Calling Procedure with ref cursor param via LinqConnect

Post by killpapa » Wed 21 Sep 2016 13:34

Hi Devart Team,
Recently I have upgraded to dotConnect for Oracle version 9.1.97.0.
The problem that I am facing with upgraded version is, I am not able to execute a Stored Procedure which was working fine with the previous version(dotconnect for oracle 6.30.165.0).

error:

Devart.Data.Linq.LinqCommandExecutionException: Error on executing DbCommand. ---> Devart.Data.Oracle.OracleException: ORA-06550: Строка 2, столбец 3:PLS-00306: wrong number or types of arguments in call to 'xxx' ORA-06550: line 2, column 3:PL/SQL: Statement ignored

reup to 6.30.165.0, all is working.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Calling Procedure with ref cursor param via LinqConnect

Post by Shalex » Wed 21 Sep 2016 18:49

Please localize the issue and send us a small test project with the corresponding DDL script so that we can reproduce the error in our environment.

In case of >2MB attachment, we recommend either using some file exchange server (send us the corresponding link) or uploading a test project to our FTP server (the credentials will be provided by email request).

killpapa
Posts: 19
Joined: Sun 29 Jan 2012 16:12

Re: Calling Procedure with ref cursor param via LinqConnect

Post by killpapa » Thu 22 Sep 2016 06:33

I'm using version 6.30.165.0, as soon as the opportunity has been updated to version 9.1.97.0 and will send you a draft.

my stats - working procedure with return ref_cursor:

6.30.165.0 - good
7.9.333 - bad
8.5.543.0 - bad
9.1.97.0 - bad

best regards

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Calling Procedure with ref cursor param via LinqConnect

Post by Shalex » Mon 26 Sep 2016 16:40

Thank you for the test project. We will investigate the issue and notify you about the result.

killpapa
Posts: 19
Joined: Sun 29 Jan 2012 16:12

Re: Calling Procedure with ref cursor param via LinqConnect

Post by killpapa » Tue 11 Oct 2016 07:04

Hi!
The new release will help my problem or it is necessary to wait?

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Calling Procedure with ref cursor param via LinqConnect

Post by Shalex » Tue 11 Oct 2016 16:06

You can fix the issue with your current (9.1.97) version as well. For this, add the following attribute to your TESTDELME method:

Code: Select all

[Devart.Data.Linq.Mapping.ResultType(typeof(TESTDELMEResult), 0, ResultTypeOrigin.ReturnValue)]
For more information, refer to
https://www.devart.com/linqconnect/docs ... tions.html
https://www.devart.com/linqconnect/docs ... eries.html
https://www.devart.com/linqconnect/docs ... eters.html
https://www.devart.com/linqconnect/docs ... Value.html (your case)

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Calling Procedure with ref cursor param via LinqConnect

Post by Shalex » Tue 11 Oct 2016 16:35

JIC:
to make Entity Developer generate this attribute every time you save the model: navigate to Model Settings > Attributes > select the Devart.Data.Linq assembly with all its attributes, press OK. After this, select the Devart.Data.Linq.Mapping.ResultType(Type, Int32, ResultTypeOrigin) attribute in the Attributes collection of the TESTDELME method and initialize its properties like described in my previous message

killpapa
Posts: 19
Joined: Sun 29 Jan 2012 16:12

Re: Calling Procedure with ref cursor param via LinqConnect

Post by killpapa » Wed 12 Oct 2016 12:05

it works. however it is necessary to update all similar procedures in manual of the old project.

best regards

Post Reply