Devart Forums

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.

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).

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

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

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

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)

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

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

best regards