how to call oracle stored function in C#

Question

Hi Dear All, I am working in C# with Oracl. i want to use Oracle Stored functions and Procedures in C#. I am using OLEDB.Net. Functions have parameters and stored procedures have In and out parameters . how i call these and use return values from oralce function Please tell me with code exampels. I will be thankfull................... Aahiqbhatti.

ashiqbhatti · Answer

Dear Mahesh. Thanks for reply.I see all the Posted Topics in ADO.NET Section but there is no sample for Oracle stored Functions. I am trying the call oracle function call in C# The oralce function have two parameters with datatype VARCHAR2 and function return a value Int. I am using this as in OLEDB. Please help me how to get and display the return value of oracle function in C# I will be thankful. C# Code is as below. ________________________________________________________ string ConnStr="Provider=OraOLEDB.Oracle;Data source=AASHIQ;Userdrcomp;Password=ali"; OleDbConnection Conn = new OleDbConnection(ConnStr); Conn.Open(); String strProcName = "{?=CALL Login(?, ?) }"; OleDbDataAdapter sqlCommand = new OleDbDataAdapter(strProcName, Conn); sqlCommand.SelectCommand.CommandType = CommandType.Text; OleDbParameter param1 = new OleDbParameter("username1", DbType.VarChar, 20); param1.Direction = ParameterDirection.Input; sqlCommand.SelectCommand.Parameters.Add(param1).Value = "ALI" ; OleDbParameter param2 = new OleDbParameter("pass1", OleDbType.VarChar, 20); param1.Direction = ParameterDirection.Input; sqlCommand.SelectCommand.Parameters.Add(param2).Value = "ALI" ; OleDbParameter param4 = new OleDbParameter ("result", OleDbType.Integer); param4.Direction = ParameterDirection.ReturnValue; sqlCommand.SelectCommand.Parameters.Add(param4); sqlCommand.SelectCommand.ExecuteNonQuery(); _____________________________________________________________

Mahesh Chand · Answer

There are many samples in ADO.NET section of C# Corner.

how to call oracle stored function in C#

Answers (2)