I just started reading about stored procedures. Can anyone please help me call a stored procedure in oracle from C# Thanks in advance
+1
A:
It's basically the same mechanism as for a non query command with:
- command.CommandText = the name of the stored procedure
- command.CommandType
=
CommandType.StoredProcedure - As many calls to command.Parameters.Add as the number of parameters the sp requires
- command.ExecuteNonQuery
There are plenty of examples out there, the first one returned by Google is this one
There's also a little trap you might fall into, if your SP is a function, your return value parameter must be first in the parameters collection
vc 74
2010-10-15 08:32:39
A:
In .Net through version 4 this can be done the same way as for SQL Server Stored Procs but note that you need:
using System.Data.OracleClient;
There are some system requirements here that you should verify are OK in your scenario.
Microsoft is deprecating this namespace as of .Net 4 so third-party providers will be needed in the future. With this in mind, you may be better off using Oracle Data Provider for .Net (ODP.NET) from the word go - this has optimizations that are not in the Microsoft classes. There are other third-party options, but Oracle has a strong vested interest in keeping .Net developers on board so theirs should be good.
Steve Townsend
2010-10-15 09:57:33