while (reader.Read()) Console.WriteLine($"reader["first_name"] reader["last_name"]");

conn.Open(); OracleCommand cmd = new OracleCommand("GET_EMPLOYEES_BY_DEPT", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("p_dept_id", OracleDbType.Int32).Value = 30; cmd.Parameters.Add("p_cursor", OracleDbType.RefCursor).Direction = ParameterDirection.Output; using (OracleDataReader reader = cmd.ExecuteReader()) oracle.dataaccess

.NET App → Oracle.DataAccess.dll → Oracle Client → SQL*Net → Oracle Database while (reader