Stored Procedures with ADO.NET

You can call stored procedures with ADO.NET. However, when calling stored procedures, be aware that the following features are not currently supported:
  • Named parameters
  • Oracle stored procedures returning a result set using Microsoft or Oracle managed providers (the ODBC provider can return Oracle result sets without problems)
  • Stored procedures called by dynamic SQL