private bool booking(Reservacion res) { // funcion que voy a procesar string sp = "FNRVA_OBEES"; bool ok; UConnection DB = new UConnection(Properties.Settings.Default.ipBD, Properties.Settings.Default.serverBD, Properties.Settings.Default.usuarioBD, Properties.Settings.Default.passBD); OracleCommand cmd = new OracleCommand(); OracleParameter retval = new OracleParameter("V_RESERVA", OracleDbType.Varchar2, 50); retval.Direction = ParameterDirection.ReturnValue; cmd.Parameters.Add(retval); //res.Rva_oasis_rva = Convert.ToString(retval.Value); OracleParameter inval = new OracleParameter("inval", OracleDbType.Varchar2); inval.Direction = ParameterDirection.Input; inval.Value = res.Rva_action; cmd.Parameters.Add(inval); OracleParameter inval2 = new OracleParameter("inval2", OracleDbType.Varchar2); inval2.Direction = ParameterDirection.Input; inval2.Value = res.Rva_uniqueID; cmd.Parameters.Add(inval2); OracleParameter inval3 = new OracleParameter("inval3", OracleDbType.Varchar2); inval3.Direction = ParameterDirection.Input; inval3.Value = fecha_actual; cmd.Parameters.Add(inval3); OracleParameter inval4 = new OracleParameter("inval4", OracleDbType.Varchar2); inval4.Direction = ParameterDirection.Input; inval4.Value = hora_actual; cmd.Parameters.Add(inval4); OracleParameter outval = new OracleParameter("outval", OracleDbType.Varchar2, 50); outval.Direction = ParameterDirection.Output; cmd.Parameters.Add(outval); //res.Rva_oasis_errcode = Convert.ToString(outval.Value); OracleParameter outval2 = new OracleParameter("outval2", OracleDbType.Varchar2, 50); outval2.Direction = ParameterDirection.Output; cmd.Parameters.Add(outval2); //res.Rva_oasis_errdesc = Convert.ToString(outval2.Value); ok = DB.EjecutaSP(ref cmd, sp); if (ok) { Reserva = cmd.Parameters["V_RESERVA"].Value.ToString(); ErrorCode = cmd.Parameters["ERRCODE"].Value.ToString(); ErrDesc = cmd.Parameters["ERRDESC"].Value.ToString(); } return(ok); }