title: vb.net error while trying to use OracleDataReader
body: <p>I am trying to get data from my Oracle Sql Developer server. The connection is OK but i seem to encounter a problem while trying to get the actual data from the DB. I keep getting the following error :
    <em>{"ORA-00942: table or view does not exist"}</em></p>
  
  <p>The code i used is the following : </p>
  
  <pre><code>Public connectionString As String
  Public sqlCom As String
  Public command As New OracleCommand
  Public con As New OracleConnection
  Public dr As OracleDataReader
  connectionString = "Data Source=orcl; User Id=system; Password=parola1234;"
  con = New OracleConnection(connectionString)
  Try
      con.Open()
      ''MessageBox.Show("succes")
  Catch ex As Exception
      MessageBox.Show(ex.ToString)
  End Try
  command.Connection = con
  sqlCom = "select TICKETID from system.TICKETS where TICKETID = " + txtTicket.Text
  command.CommandText = sqlCom
  dr = command.ExecuteReader()
  If (dr.HasRows) Then
     While (dr.Read())
         Me.Hide()
         GlobalVariables.ticketNOText = txtTicket.Text
         Tracking.Show()
     End While
  Else
  MessageBox.Show("Invalid Ticket Number!")
  End If
  </code></pre>
  
  <p>Here is a picture of my SQL DB :
  <a href="https://i.stack.imgur.com/6iteQ.png" rel="nofollow noreferrer">1</a></p>