ORA-00903: invalid table name on preSQL in Output

Question

Hello,

I am trying to do a merge query in my preSQL output tool, but am getting a ORA-00903 invalid table name on my PreSQL query. I know the oracle database table is called GROUPS, which looks like a reserved word and think this is why I am getting this error.

Is there a way to fix this so I can get the PreSQL query to run the process?

thanks,

Lloyd

Nate1 · Accepted Answer

Hi @lruchlin

If the reserved word is the problem you should be able use SCHEMA_NAME.TABLE_NAME to still access the table. Another option would be to put it in double quotes. In oracle double quotes signal a database object.

It neither of those work we might need some more info to solve it.