Re: Anyone know how to call an Oracle function from C#?
- From: "David Browne" <davidbaxterbrowne no potted meat@xxxxxxxxxxx>
- Date: Fri, 19 Jan 2007 14:13:04 -0600
"Steve Kershaw" <steve_kershaw@xxxxxxxxx> wrote in message news:1169226586.195498.27980@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
David,
Thanks that worked! However, it only works with
System.Data.OracleClient NOT Oracle.DataAccess.Client. When will Oracle
get with the program!?
Well, you can always just use CommandType.Text. And set command text to
string sql = @"
begin
:p_rv := HDB.PRL_PAY_PERIOD_PAYROLL_PKG.get_rec_final_qtr_count(:p_year,:p_quarter);
end;
";
This is the exact same block you can use in SqlPlus.
Then bind an output parameter and two input parameters. Be careful, ODP.NET used positional parameter binding by default.
David
.
- References:
- Anyone know how to call an Oracle function from C#?
- From: Steve Kershaw
- Re: Anyone know how to call an Oracle function from C#?
- From: David Browne
- Re: Anyone know how to call an Oracle function from C#?
- From: Steve Kershaw
- Anyone know how to call an Oracle function from C#?
- Prev by Date: Re: disable ViewState ?
- Next by Date: DataBinding for FileUpload
- Previous by thread: Re: Anyone know how to call an Oracle function from C#?
- Next by thread: ViewState and ControlTree section in Trace of an ASP.NET page
- Index(es):
Relevant Pages
|
