How to call an Oracle function with C# (Asp.Net)

using Oracle.DataAccess.Client;

Then, we create a connection object of type OracleConnection, open the connection, and declare an OracleCommand object using the stored procedure name as an input argument. One of the properties we want to set in the OracleCommand object cmd is the CommandType which will be CommandType.StoredProcedure.

Now we want to declare the input and output parameters to and from the stored procedure. We use a class of type OracleParameter to do this. The arguments to the constructor for OracleParameter are the parameter name and the Oracle database type (OracleDbType). As a property to our parameter objects, we give the direction of input or output (ParameterDirection.Input, ParameterDirection.Output). Finally, we execute the stored procedure through the ExecuteNonQuery method on the cmd object and close the connection. The return value from the stored procedure can be found in the "dv" parameter of the cmd object prm3 if all is successful.

OracleParameter prm3 = new OracleParameter("dv",OracleDbType.Varchar2,10);
prm3.Direction = ParameterDirection.Output;
cmd.Parameters.Add(prm3);

cmd.ExecuteNonQuery();
conn.Close();
Console.WriteLine("Division is: " + cmd.Parameters["dv"].Value);