Empty response Oracle c# WPF output query results to table?

Question

Oracle

Good hour!

See this question, I'm making a connection to a database like Oracle. I send a request, I get a response, but for some reason the response does not contain rows, but it contains the names of the columns, I can’t figure out where to dig ...

Connection string:

<connectionStrings>
    <add name="myConnectionString"
         connectionString="DATA SOURCE=localhost:1521/orcl;USER ID = SYS;PASSWORD = 111111111;DBA PRIVILEGE = SYSDBA;"
         providerName="Oracle.ManagedDataAccess.Client"/>
  </connectionStrings>

The body of the request execution and insertion into the table:

private void updateMyDataGrid() {
            OracleCommand cmd = con.CreateCommand();

            cmd.CommandText = "select * from firm";

            cmd.CommandType = CommandType.Text;
            OracleDataReader dr = cmd.ExecuteReader();
            DataTable dt = new DataTable();
            dt.Load(dr);

            //помещаю полученный результат в DataGrid
            myDataGrid.ItemsSource = dt.DefaultView;
            dr.Close();
        }

The result of the query:


As you can see, the table header comes and that's it. Where am I wrong or what am I doing wrong?

Well, actually the table itself to which the request goes:

Answer 1

Check, after loading, the HasErrors property and see the errors via GetErrors()

Answer 2

There was a poop about magic, I don’t know whether oracle got used to my computer or, but it just took it and it worked as it should .... so I started to see the errors on your advice ... Thanks for the tips anyway)