ORA-00904: invalid identifier

Details
Written by: Stanko Milosev
Category: Oracle
Hits: 8146
If you ever received this error then try to write field names in the Oracle with upper case, or use quotas.

ora-01036 illegal variable name/number

Details
Written by: Stanko Milosev
Category: Oracle
Hits: 5881
Error: ora-01036 illegal variable name/number will happen if you added parameter in Param of TSQLQuery and there is no parameter in the SQL (there is no anything as :Parameter)