How to get the data in return is null now

Shahbaz Kaware

public Employee GetEmployeewithID(int sEQ_EMP_ID)

{

int i;

Employee objEmp;

objEmp = new Employee();

try

{

objOracleCommand = new OracleCommand();

objOracleCommand.Connection = new OracleConnection(cs);

objOracleCommand.Connection.Open();

objOracleCommand.CommandType = CommandType.StoredProcedure;

objOracleCommand.CommandText = "PKG_EMPLOYEE.Get_Employee_with_ID";

objOracleCommand.Parameters.AddWithValue("P_SEQ_EMP_ID", sEQ_EMP_ID);

objOracleCommand.Parameters.Add("OUT_RESULT", OracleType.Cursor).Direction = ParameterDirection.Output;

objOracleDataAdapter = new OracleDataAdapter(objOracleCommand);

i = objOracleCommand.ExecuteNonQuery();

return objEmp;

}

catch (Exception ex)

{

throw ex;

}

3 Replies

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

Mageshwaran R6y ago
Hi,
Try this code:
OracleCommand oracmd = new OracleCommand("PORT_CALL_PROCEDEURE", oraconn);
oracmd.CommandType = CommandType.StoredProcedure;
oracmd.Parameters.Add("query_in", OracleDbType.Varchar2, 10000000,
    "select * from dual where dummy='X'", ParameterDirection.Input);
oracmd.Parameters.Add("result", OracleDbType.Varchar2, 10000000,
    null, ParameterDirection.Output);
oracmd.ExecuteNonQuery();
Console.WriteLine(oracmd.Parameters["result"].Value);
0
Subbarao A6y ago
Hi

you need to get the data from the data Adapter. Please check below link

https://www.c-sharpcorner.com/article/dataadapter-in-C-Sharp/
0
Amit Gupta6y ago
Couldn't able to get your question property? Do you want objEmp as return type?
0