sb.Append("BEGIN INSERT INTO cliente( DATE_ALTA,NOMBRE, APELLIDO, CUIT)");
sb.Append("VALUES(SYSDATE,:NOMBRE,:APELLIDO,:CUIT) returning ID INTO :ID; END;");
using (OracleConnection conn = new OracleConnection(DA.ConeccionStringDDJJ))
{
using (OracleCommand comm = new OracleCommand(sb.ToString(), conn))
{
.........
comm.Parameters.Add(":ID", OracleDbType.Int32, 10,parameterDirection.ReturnValue);
}
}
No hay comentarios:
Publicar un comentario