Public Function getList(ByVal pVar As String) As DataSet Dim ds As New DataSet() Dim oraData As OracleDataAdapter = Nothing Try Using command As New OracleCommand(q_get_menu, AccesoDatosOracle.Instance) AccesoDatosOracle.Instance.Open() command.CommandType = CommandType.StoredProcedure Dim parm1 As OracleParameter = New OracleParameter("pVAR", OracleDbType.Varchar2) parm1.Direction = ParameterDirection.Input parm1.Value = pVar command.Parameters.Add(parm1) Dim parm2 As OracleParameter = New OracleParameter("pcur_tablapadre", OracleDbType.RefCursor) parm2.Direction = ParameterDirection.Input parm2.Value = DBNull.Value command.Parameters.Add(parm2) Dim parm3 As OracleParameter = New OracleParameter("pcur_tablahijo", OracleDbType.RefCursor) parm3.Direction = ParameterDirection.Input parm3.Value = DBNull.Value command.Parameters.Add(parm3) command.BindByName = True oraData = New OracleDataAdapter(command) oraData.Fill(ds) End Using Catch ex As Exception Console.WriteLine("EL error es: " + ex.Message) Throw ex Finally AccesoDatosOracle.Instance.Close() End Try Return ds End Function
.Direction = ParameterDirection.Input
.Direction = ParameterDirection.Output
Dim ds As New DataSet()
Dim ds As System.Nullable(Of DateSet) = New DataSet()
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)