How to declare param in c# function to get both inputoutput with oracle db?

Question

I am newly with c# MVC that passing param value to oracle PROCEDURE. It is possible to declare param set both input and output from db? that currently my code:

 public string get_data(out string send_get)

 cmd.Parameters.Add("send_get", OracleDbType.Varchar2).Direction = ParameterDirection.InputOutput;

Am i right with this param declaration? If anyone have experience with it please kindly help me please. thanks in advance

You would be better off with creation of separate `OracleParameter` object and then using the object to set various properties, before adding that to the Parameter Collection — Mrinal Kamboj, Sep 03 '18 at 06:13

Gauravsa · Answer 1 · 2018-09-03T06:26:56.477

0

If you try the following:

cmd.Parameters.Add("send_get", OracleDbType.Varchar2).Direction = ParameterDirection.InputOutput;

you will get a warning "SqlParameterCollection.Add is obsolete and deprecated". You can use AddWithValue.

Or you can use this as well:

OracleParameter par = new OracleParameter("@param1", OracleDbType.Varchar2, 250);
par.Direction = ParameterDirection.InputOutput;
par.Value = "Foo";
cmd.Parameters.Add(par);

For deprecated method Add refer to this SO:

SqlCommand Parameters Add vs. AddWithValue

edited Sep 03 '18 at 06:26

answered Sep 03 '18 at 04:52

Gauravsa

6,330
2
21
30

Thanks but my db not SqlDbType it oracle can i replace SqlDbType to OracleDbType? – Chhenghong EANG Sep 03 '18 at 05:01
@chhenghong you shall certainly use `OracleDbType`, since `SqlDbType` is meant for the Sql Server – Mrinal Kamboj Sep 03 '18 at 05:17
edited the answer. If you are ok, please mark it as answer. It will help others also. – Gauravsa Sep 03 '18 at 05:34
@Gauravsa your answer still contain parts of `SqlParameter`, remove that and verify the behavior for `OracleParameter` – Mrinal Kamboj Sep 03 '18 at 06:11
@Gauravsa also why would the `SqlParameterCollection.Add`method deprecate, Could you post the Link with details – Mrinal Kamboj Sep 03 '18 at 06:14
Just copied from visual studio ide. It compiles. – Gauravsa Sep 03 '18 at 06:23
See here. IDE shows squiggly lines and indicates it as deprecated. See here https://stackoverflow.com/questions/31731035/sqlparametercollection-add-is-obsolete-and-deprecated – Gauravsa Sep 03 '18 at 06:24

How to declare param in c# function to get both inputoutput with oracle db?

1 Answers1