Invalid host/bind variable name ORA-01745

[Valgardur]

While updating a old application I get "invalid host/bind variable name" for a query

Code: Select all

select Pot, count(*) value
from Pots
WHERE Pot BETWEEN :PotFrom AND :PotTo 
  and Dt >= ( :Date -10 )
  and Dt < (:Date + 1)
Group by Pot

When trying to work with TOraQuery.

If I change ":Date" to something else, ":Dat" everything is fine.

The problem is probably the fact the "Date" is a reserved word, but in this case, only as a parameter.

And yes (long explanation, but) simply changing to ":Dat" will take (almost) forever.

[MaximG]

You cannot use an auxiliary word DATE as a query parameter name, it is Oracle server restriction that is demonstrated by the error ORA-01745

[Valgardur]

Thanks, but this actually does work in old code (using BDE)

[aricjoshua]

After doing some research, I discovered that a recent Windows 10 upgrade had screwed up numerous system files. The installation of the Access Database Engine was suggested. This is what I did, and our issues were resolved.

[MaximG]

Hi there!

Thnak you for your reply!
Please explain how the Access Database Engine installation is related to the ORA-01745 error?
Looking forward to your reply!