Error : each parameter can only be referenced once

[ucandoit1010]

Hi I have subquery in my sql script like this :

SELECT * FROM XTABLE X , (SELECT * FROM ATABLE WHERE ORG =: OID ) A WHERE X.ORG =: OID AND A.ORG =: OID

I am using Query execute SQL
new { OID = OID }
, but got error

When passing parameters by position, each parameter can only be referenced once

cany anyone guide me what's going on ? thank you .

[mgravell]

as it says: it is having to represent that using pseudo-positional mapping of the parameters (which does surprise me, actually) - in which case it can only use each "named" parameter once, because in reality it isn't named. The trick, then, is to pass two different parameters with the same value but different names.

…

On Sun, 28 Oct 2018, 04:48 TaiwanHotDog, ***@***.***> wrote: Hi I have subquery in my sql script like this : SELECT * FROM (SELECT * FROM ATABLE WHERE ORG =: OID ) A WHERE A.ORG =: OID I am using Query <https://dapper-tutorial.net/query>execute SQL new { OID = OID } , but got error When passing parameters by position, each parameter can only be referenced once cany anyone guide me what's going on ? thank you . — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#1150>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AABDsJgykNWuyiWl-SJNNb-_0o-CWwMuks5upTcggaJpZM4X9yAT> .

[ucandoit1010]

THANK YOU .
we go it !

The problem is sql file without utf8 encoding,
but many chinese words in sql file !
event use oraclecommand still got error.