Call oracle function from c# code

Question

5.00/5 (1 vote)

See more:

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 />

i need to call it from oracleDataAdapter and thanks

Posted 17-Sep-12 0:48am

Member 8263928

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sandip.Nascar · Answer 1 · 2012-09-17T01:42:00

Solution 1

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

Posted 17-Sep-12 1:42am

Sandip.Nascar

_Amy · Answer 2 · 2012-09-17T01:54:00

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:

C#

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