how to call oracle stored function in C#

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.

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(); _____________________________________________________________

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

ashiqbhatti22y ago
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 Chand22y ago
There are many samples in ADO.NET section of C# Corner.