I have a query like this

update tableA
set fldA = fldA / :pm1,
fldB = fldB / :pm1,
fldC = fldC / :pm1,
fldD = fldD / :pm1,
fldE = fldE / :pm1,
fldF = fldF / :pm1
where <some condition = :pm2 >

when I do a prepare on query I get 2 parameters in ParameterList.
But I have a similar query where I all pm1's are interpreted as
different parameters. What could be causing it?

Sandeep

Software Developer
CFL
sandeep@...
http://www.cfl.co.nz