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