Stored procedure problem in dotConnect 6.60.268

Stored procedure problem in dotConnect 6.60.268

Postby 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
 
Posts: 89
Joined: Tue 26 Oct 2010 08:29

Postby 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?
object
 
Posts: 89
Joined: Tue 26 Oct 2010 08:29

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

Postby object » Tue 10 Jan 2012 12:39

Thanks!
object
 
Posts: 89
Joined: Tue 26 Oct 2010 08:29

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


Return to dotConnect for Oracle