从C#代码调用oracle函数 [英] Call oracle function from c# code

问题描述

请我提供有关从C#方法调用函数的帮助.
我有这个功能

please i need help about calling function from C# method ..
i have this function

<br />
ACC.GET_WAFR_FROM_DETAIL<br />
  ( LOC     VARCHAR2,<br />
    BDGYYY  VARCHAR2,<br />
    ACC1    VARCHAR2,<br />
    ACC2    VARCHAR2,<br />
    ACC3    VARCHAR2,<br />
    ACC4    VARCHAR2) RETURN  NUMBER IS<br />

我需要从oracleDataAdapter调用它，谢谢

i need to call it from oracleDataAdapter and thanks

推荐答案

通过下面的链接，
http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/hol08/dotnet/getstarted-c/getstarted_c_otn.htm [

Go through the link below,
http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/hol08/dotnet/getstarted-c/getstarted_c_otn.htm[^]

This is as simple as using SqlDataAdapter for Sql Server.

Hope this helps.
cheers

您需要遵循从sql调用SP时所遵循的相同步骤.您可以像这样调用oracle函数:

You need to follow the same steps which you used to follow while calling the SP from sql. You can call a oracle function like this:

using (OracleConnection con = new OracleConnection("Data Source=Test;User Id=Test;Password=Test;"))
{
    con.Open();
    OracleCommand cmd = new OracleCommand("ACC.GET_WAFR_FROM_DETAIL");
    cmd.CommandType = System.Data.CommandType.StoredProcedure;
    //Add your parameters here
    cmd.Connection = cnn;
    OracleDataReader odr = cmd.ExecuteReader();
    while (odr.Read())
    {
        Console.WriteLine(odr.GetOracleValue(0));
    }
    Console.ReadLine();
}

--Amit

--Amit

这篇关于从C#代码调用oracle函数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！