ORA-01745 Invalid Host/Bind Variable Name: update with rowid

David Lipschitz · Post by **David Lipschitz** » Fri 23 Mar 2012 09:20

I am porting a project to ODAC and trying to convince a client to move off the BDE. However, I have a problem in a TOraQuery.

The following query returns the error message in the subject:
update aa.accpacarrecon
set amtpaid = (incvat * nvl(totalpaid,0) / :totalinvamt)
where rowid=:rowid

I have replaced the parameters in TOAD and the query works:
update aa.accpacarrecon
set amtpaid = (incvat * nvl(totalpaid,0) / 114193.69)
where rowid='AAAbEpAAMAAAAQjAAR'

The query also worked in the BDE.

Using Delphi 7.

David Lipschitz · Post by **David Lipschitz** » Fri 23 Mar 2012 09:49

I fixed the problem by changing the parameter from :rowid to :rowidvar.

AlexP · Post by **AlexP** » Fri 23 Mar 2012 11:11

Hello,

ROWID is an Oracle keyword, and since we, unlike BDE and ADO, don't change parameter names with their serial numbers (e.g. :rowid -> :1), this problem occurs. Your decision to rename parameters is right.