Error ORA-00942 TABLE DOES NOT EXIST occurring in System.Data.OracleClient. VB.NET

0

I have an application on using .Net Framework 2.0 .

Below is a snippet of my application code:

strComando = "SELECT CD_LOCALIDADE, NO_LOCALIDADE FROM COPAGIS_GDB.MUB_LOCALIDADES WHERE FL_IMPLANTADO='S' ORDER BY NO_LOCALIDADE"
fsOarquivo.WriteLine(strComando)
pComando = _controleAcessoDados.ProxyBD.MontarComando(strComando)
fsOarquivo.WriteLine(pComando.CommandText)
dataAdapter = New OracleDataAdapter(pComando)
fsOarquivo.WriteLine(dataAdapter.SelectCommand.CommandText)
dataAdapter.Fill(tblTabelas)
fsOarquivo.WriteLine(tblTabelas)

Running this snippet of code produces the error

ORA-00942: Table or view does not exist

in command

dataAdapter.Fill(tblTabelas)

I used sqlnet to generate a trace to show what the oracle client is receiving from the application. Follow the trace section below.

Notice in the attached sqlnet trace image that the SQL code is modified in the trace file. The number '5' has been added to the table name.

Can anyone tell me why this is happening? I'm using System.Data.OracleClient from Microsoft.

    
asked by anonymous 13.03.2014 / 15:14

1 answer

1

Also see if the user who logged in to the DB is the OWNER of the table, not being and not wanting to change change the select to something of the type

select * from owner.tabela

Also see if the login user has the slect GRANT of this table / view.

    
14.03.2014 / 18:49