I have an application on vb.net 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.