Search code examples
oracledelphiodac

ODAC Field 'column_name' not found in query columns without alias or table name

Recently we've upgraded our ODAC(Oracle Data Access Components) to version 10.1.5. We started to notice a weird problem. When you execute a query, without specifying the table's name or alias it results in the following error: "Field column_name not found".

Example of working code:

select principalimagem.data_inicio from geral.principalimagem

Another example of working code:

select p.data_inicio from geral.principalimagem p

If you remove the table name or the "p" alias, it will result in an error, with the exactly message above.

For some of my clients, internally, It does not result in the error, but if I connect remotely(outside from their local network), it does. I already changed the TNSNames.ora alias to be exactly like theirs, but it did no good. Any clue from what I should look for? Thanks.

Solution

  • Turns out the problem was firewall related. The error was very weird itself, and we had the same error sometimes while writing packages and procedures.

    Thanks for the help