Connection/Command Error Text Location

BrianWren · August 4th, 2008, 05:02 PM

Given:

Code:

    If c Is Nothing Then
        c.ConnectionString = CnctStr() ' <ââ<<< A UDF.
        c.Open
        If c.State <> ConnectionState.Open Then 
            MsgBox("Failed to open connection", _
                   MsgBoxStyle.Critical, _
                   "Error")
            Exit Sub
        End If
    End If

    Dim cmd As New _
        OracleCommand("ALTER USER " & txtLogin.Text & " " & _
                      "IDENTIFIED BY " & txtNewPW.Text, _
                      c)

    Try
        cmd.ExecuteNonQuery()
    Catch ex As Exception

    End Try

If the password cannot be used (already been used, malformed, whatever) where will the text of the error be found?

In SQL*Plus, the primitive utility for communicating with Oracle, a message like that would be on the lines below the statement. So Oracle must be returning the characters that make up the message. But where does .NET put the message?

Koeno · September 8th, 2008, 06:00 AM

I Thought there is an exception thrown with the message in it. In that case you could use the catchblock. But I could be wrong.