oracle execute 返回表,如何使用ExecuteScalar從Oracle數據庫返回單個值？

使用下面的代碼從數據庫中返回一條記錄。我讀過ExecuteScalar是返回單個記錄的正確方法。我從來沒有能夠得到ExecuteScalar工作。我將如何改變這個使用ExecuteScalar在VB.Net中返回單個值？如何使用ExecuteScalar從Oracle數據庫返回單個值？

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