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.