Stored procedure problem in dotConnect 6.60.268

object · Post by **object** » Wed 04 Jan 2012 10:36

We had to rollback latest dotConnect version because of a failure it caused to Oracle stored procedures.

Here is a stored procedure definition in a model:

Code: Select all

"DistributionFiles" is a fake entity set, i.e. there is no such table in Oracle database, it is defined to server as a complex type (because complex types are not supported by OData that we're using).

This definition used to work with previous versions of dotConnect. However latest release causes the following exception:

Code: Select all

Test 'Nrk.OnDemand.Backend.GranittModel.IntegrationTests.GranittModelTests.get_files_for_upload_should_return_collection' failed:
	Test method Nrk.OnDemand.Backend.GranittModel.IntegrationTests.GranittModelTests.get_files_for_upload_should_return_collection threw exception: 
System.Data.EntityCommandExecutionException: An error occurred while executing the command definition. See the inner exception for details. ---> System.InvalidCastException: Unable to cast object of type 'Devart.Data.Oracle.OracleParameter' to type 'Devart.Data.Oracle.Entity.m'.
	at Devart.Data.Oracle.Entity.f.d()
	at Devart.Data.Oracle.Entity.f.b(CommandBehavior A_0)
	at HibernatingRhinos.Profiler.Appender.ProfiledDataAccess.ProfiledCommand.ExecuteDbDataReader(CommandBehavior behavior)
	at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
	 --- End of inner exception stack trace ---
	at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
	at System.Data.Objects.ObjectContext.CreateFunctionObjectResult[TElement](EntityCommand entityCommand, EntitySet entitySet, EdmType edmType, MergeOption mergeOption)
	at System.Data.Objects.ObjectContext.ExecuteFunction[TElement](String functionName, MergeOption mergeOption, ObjectParameter[] parameters)
	at System.Data.Objects.ObjectContext.ExecuteFunction[TElement](String functionName, ObjectParameter[] parameters)

Any help is appreciated.

object · Post by **object** » Tue 10 Jan 2012 08:03

Hi,

I wonder about the status of this issue. Is it reproduced? Do you need help reproducing it?

Shalex · Post by **Shalex** » Tue 10 Jan 2012 12:03

The problem is fixed. Look forward to the next build of dotConnect for Oracle. We will post here when it is available for download.

object · Post by **object** » Tue 10 Jan 2012 12:39

Thanks!

Shalex · Post by **Shalex** » Thu 12 Jan 2012 17:03

New build of dotConnect for Oracle 6.60.283 is available for download now!
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://www.devart.com/forums/viewtopic.php?t=23129 .