Hi All,

I am facing some issue in dealing with named sql query.

Im pasting the following query.

<resultset name="abc">
<return alias="a" class="com.A"/>
</resultset>


<sql-query name="abcd" resultset-ref="abc" >
<![CDATA[

SELECT DISTINCT {a.*}
FROM CA.A a
(
SELECT DISTINCT {a.*}
FROM CA.A a
left join CA.AC or ON a.OID = or.OID

UNION ALL

SELECT DISTINCT {a.*}
FROM CA.A a
left join CA.DC or ON a.OID = or.OID
) r

WHERE
r = a and a NOT IN (:list_of_a)

]]>
</sql-query>


Here i am trying to pass a parameter list to sql-query. This is not working .
Is there any way of doing this .
The parameter list list_of_a contains objects of a.
How to go about this approach ?

thnx in advance