Calling Procedure with ref cursor param via LinqConnect
Calling Procedure with ref cursor param via LinqConnect
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.
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.
Re: Calling Procedure with ref cursor param via LinqConnect
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).
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).
Re: Calling Procedure with ref cursor param via LinqConnect
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
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
Re: Calling Procedure with ref cursor param via LinqConnect
Thank you for the test project. We will investigate the issue and notify you about the result.
Re: Calling Procedure with ref cursor param via LinqConnect
Hi!
The new release will help my problem or it is necessary to wait?
The new release will help my problem or it is necessary to wait?
Re: Calling Procedure with ref cursor param via LinqConnect
You can fix the issue with your current (9.1.97) version as well. For this, add the following attribute to your TESTDELME method:
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)
Code: Select all
[Devart.Data.Linq.Mapping.ResultType(typeof(TESTDELMEResult), 0, ResultTypeOrigin.ReturnValue)]
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)
Re: Calling Procedure with ref cursor param via LinqConnect
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
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
Re: Calling Procedure with ref cursor param via LinqConnect
it works. however it is necessary to update all similar procedures in manual of the old project.
best regards
best regards