SAP Knowledge Base Article - Preview

1998389 - Exception thrown executing stored proc with output parameter: System.Data.EntityCommandExecutionException: An error occurred while executing the command definition. See the inner exception for details.

Symptom

While creating EDM (Entity Data Model) project in Visual Studio (2010 in this case) to model and execute ASE (Adaptive Server Enterprise) stored procedures with output parameter as char/varchar, Exception is thrown:

Exception: System.Data.EntityCommandExecutionException: An error occurred while executing the command definition. See the inner exception for details. ---> System.Runtime.InteropServices.SEHException: External component has thrown an exception.
   at Sybase.Data.AseClient.Unmanaged.BindParameter(IntPtr pCommandHandle, String paramName, AseDbType sqlType, Int32 precision, Int32 scale, String value, ParameterDirection direction, Int32 size, Int32 isNull)
   at Sybase.Data.AseClient1.AseCommand.BindParameters()
   at Sybase.Data.AseClient1.AseCommand.Execute(CommandBehavior commandBehavior)
   at Sybase.Data.AseClient1.AseCommand._ExecuteReader(CommandBehavior commandBehavior)
   at Sybase.Data.AseClient1.AseCommand.ExecuteReader(CommandBehavior commandBehavior)
   at Sybase.Data.AseClient.AseCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.ExecuteReader(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, ReadOnlyMetadataCollection`1 entitySets, EdmType[] edmTypes, 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)
   at InOutTest.pubs3Entities.storeid_proc_out(String stor_id, ObjectParameter stor_name_out) in C:\...\Model1.Designer.cs:line 128

 


Read more...

Environment

  • SAP ASE SDK 15.7 SP121, 4.0 ADO.NET Provider (4.157.1212.0)
  • ASE 15.7
  • msdev (Visual Studio) 2010 using EDM 4.0, EF (Entity Framework) 4.0
  • Windows x86/x64, Win 7/2008R2

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP Adaptive Server Enterprise SDK 16.0 ; Sybase Software Developer Kit 15.7

Keywords

framework, edm, adodotnet, parms, "output parm", "output parms", param, params , KBA , BC-SYB-SDK , SDK , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.