How pass a parameter to IN Operator?

Question

I'm Trying, pass a long array for a named query (native SQL) for to use in an IN STATEMENT: Like this:

(...) WHERE Identificator IN (:pIdes)

I tried pass my ides as long[]:

 ctx.GetNamedQuery("NamedQueryName")                                          
                   .SetParameter<long[]>("pIdes", Identificators)
                   .List<EmpreendimentoInputReport>();

and as a string

 ctx.GetNamedQuery("NamedQueryName")                                          
                   .SetParameter<string>("pIdes", Identificators)
                   .List<EmpreendimentoInputReport>();

When the parameter is a string return nothing, whem is a long[] return this Oracle error:

"Oracle.DataAccess.Client.OracleException: ORA-00932: tipos de dados inconsistentes: esperava NUMBER obteve BINARY"

http://stackoverflow.com/questions/2388021/parameterizing-a-hql-in-clause-using-hqlbasedquery — Mauricio Scheffer, May 03 '10 at 17:11

score 14 · Accepted Answer · answered May 03 '10 at 14:37

14

Use SetParameterList instead of SetParameter.

answered May 03 '10 at 14:37

Diego Mijelshon

52,548
16
116
154

How pass a parameter to IN Operator?

1 Answers1