"Table or view does not exist" error when updating to Oracle

By: Lucas Bantner

Abstract: This FAQ describes a common error when making updates via dbExpress to Oracle

Question:

I have a TSQLQuery connected to Oracle that executes a simple select statement and displays that in a grid. However, when I try to call ApplyUpdates on the ClientDataSet, I get the error Table or view does not exist.

Answer:

Oracle is very finicky about the case of symbols like table names. Unless you physically quoted the table name when you created it, it probably got mangled to upper case. Try rewriting your select sql statement so that the table names are in upper case, i.e. Select * From MYTABLE.


Server Response from: ETNASC03