title: Parsing DateTime From VB.NET to Oracle Stored Procedure
body: <p>I've been struggling with Oracle's Date Time Function. </p>
  
  <p>I have stored procedure which runs properly and well done but I don't have any idea how can I parsing the date from VB.net so that the stored procedure can receive the value from VB.net?</p>
  
  <p>Does anyone know how to parsing the value from VB.net, in this case I talk about the Date Time so it will be a hour, second and minute. </p>
  
  <p>Thank you so much</p>
  
  <p>Here's the .NET code</p>
  
  <pre><code>Try
              Dim conn As New OracleConnection(connectionString(data(0), data(1), data(2)))
              conn.Open()
              Dim cmd As New OracleCommand
              cmd.Connection = conn
              cmd.CommandType = CommandType.StoredProcedure
              cmd.CommandText = "transactionme"
              Dim p1 As OracleParameter
              Dim p2 As OracleParameter
              Dim p3 As OracleParameter
              Dim p4 As OracleParameter
              Dim p5 As OracleParameter
              Dim p6 As OracleParameter
              Dim p7 As OracleParameter
              Dim p8 As OracleParameter
              Dim p9 As OracleParameter
              Dim p10 As OracleParameter
              p1 = cmd.Parameters.Add("param1", OracleDbType.NChar)
              p1.Value = ""
              p2 = cmd.Parameters.Add("param2", OracleDbType.NChar)
              p2.Value = "STD2"
              p3 = cmd.Parameters.Add("param3", OracleDbType.NChar)
              p3.Value = "RK001"
              p4 = cmd.Parameters.Add("param4", OracleDbType.NChar)
              p4.Value = "EK001"
              p5 = cmd.Parameters.Add("param5", OracleDbType.Date)
              p5.Value = "here is the problem"
              p6 = cmd.Parameters.Add("param6", OracleDbType.Date)
              p6.Value = "here is the problem"
              p7 = cmd.Parameters.Add("param7", OracleDbType.Date)
              p7.Value = "here is the problem"
              p8 = cmd.Parameters.Add("param8", OracleDbType.NChar)
              p8.Value = "Master Card"
              p9 = cmd.Parameters.Add("param9", OracleDbType.Int32)
              p9.Value = 30000
  
              Dim n As Integer
              n = cmd.ExecuteNonQuery()
              MessageBox.Show(n.ToString)
              conn.Close()
          Catch ex As Exception
              MessageBox.Show(ex.ToString)
          End Try
  </code></pre>
  
  <p>The parameter should be like this, have tried many things like concat and others </p>
  
  <pre><code>to_date('2012-01-23 22:00', 'YYYY-MM-DD hh24:mi')
  </code></pre>