Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Dim oracleConnection As New OracleConnection
- oracleConnection.ConnectionString = LocalConnectionString()
- Dim cmd As New OracleCommand()
- Dim o racleDataAdapter As New OracleClient.OracleDataAdapter
- cmd.Connection = oracleConnection
- cmd.CommandText = "FALCON.CMS_DATA.GET_MAX_CMS_TH"
- cmd.CommandType = CommandType.StoredProcedure
- cmd.Parameters.Add(New OracleParameter("i_FACID_C", OracleType.Char)).Value = facilityShortName
- cmd.Parameters.Add(New OracleParameter("RS_MAX", OracleType.Cursor)).Direction = ParameterDirection.Output
- Try
- Using oracleConnection
- oracleConnection.Open()
- Using oracleDataAdapter
- oracleDataAdapter = New OracleClient.OracleDataAdapter(cmd)
- Dim workingDataSet As DataSet
- oracleDataAdapter.TableMappings.Add("OutputSH", "RS_MAX")
- workingDataSet = New DataSet
- oracleDataAdapter.Fill(workingDataSet)
- For Each row As DataRow In workingDataSet.Tables(0).Rows
- Return CDate(row("MAXDATE"))
- Next
- End Using
- End Using
- oracleConnection.Open
- Dim obj as object 'Object to hold our return value
- obj = cmd.ExecuteScalar()
- oracleConnection.Close
- If obj IsNot Nothing then
- Return CDate(obj)
- end if
Add Comment
Please, Sign In to add comment