Oracle C# Output Parameter

[Chris Fink]

Why is the below code not returning an output parameter. When I run the
SQL, it is returning the value '1111', but the param1.value is empty?

string sql = String.Format("SELECT LICENSEID FROM TABLE WHERE .....");

OracleConnection cn = new OracleConnection(datasource8i);
cn.Open();

OracleCommand cmd = new OracleCommand();

cmd.CommandText = sql;

cmd.Connection = cn;

cmd.CommandType = CommandType.Text;
OracleParameter param1 = cmd.Parameters.Add("licenseID",
OracleDbType.NVarchar2,50);

param1.Direction = ParameterDirection.Output;

try

{

cmd.ExecuteNonQuery();

}

catch (Exception ex)

{

throw new Exception(ex.Message.ToString());

}

// The below line is not returning a value.

lid = param1.Value.ToString();

cn.Close();

return lid;