Calling Procedure with ref cursor param via LinqConnect

Calling Procedure with ref cursor param via LinqConnect

Postby 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.
killpapa
 
Posts: 13
Joined: Sun 29 Jan 2012 16:12

Re: Calling Procedure with ref cursor param via LinqConnect

Postby 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).
Shalex
Devart Team
 
Posts: 7654
Joined: Thu 14 Aug 2008 12:44

Re: Calling Procedure with ref cursor param via LinqConnect

Postby 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
killpapa
 
Posts: 13
Joined: Sun 29 Jan 2012 16:12

Re: Calling Procedure with ref cursor param via LinqConnect

Postby Shalex » Mon 26 Sep 2016 16:40

Thank you for the test project. We will investigate the issue and notify you about the result.
Shalex
Devart Team
 
Posts: 7654
Joined: Thu 14 Aug 2008 12:44

Re: Calling Procedure with ref cursor param via LinqConnect

Postby killpapa » Tue 11 Oct 2016 07:04

Hi!
The new release will help my problem or it is necessary to wait?
killpapa
 
Posts: 13
Joined: Sun 29 Jan 2012 16:12

Re: Calling Procedure with ref cursor param via LinqConnect

Postby 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/?Non-Composable-Functions.html
https://www.devart.com/linqconnect/docs/?Explicit-Queries.html
https://www.devart.com/linqconnect/docs/?Out-Cursor-Parameters.html
https://www.devart.com/linqconnect/docs/?Return-Value.html (your case)
Shalex
Devart Team
 
Posts: 7654
Joined: Thu 14 Aug 2008 12:44

Re: Calling Procedure with ref cursor param via LinqConnect

Postby 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
Shalex
Devart Team
 
Posts: 7654
Joined: Thu 14 Aug 2008 12:44

Re: Calling Procedure with ref cursor param via LinqConnect

Postby 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
killpapa
 
Posts: 13
Joined: Sun 29 Jan 2012 16:12


Return to dotConnect for Oracle