Hi,
I need to write some finder -

SELECT * FROM table1 WHERE id IN (id1,id2,...,idN)

id is of type long and the number of N is beforehand unknown.
I creete somewhere list of id's -

String ids = "1,2,3,4";
this string is a parameter fo my finder -

SELECT * FROM table WHERE id IN (?)

after generation deploy code looks like -

public EJSFinder findByIds(java.lang.String ids) {
...
PreparedStatement pstmt =
getPreparedStatement("SELECT * FROM table1 WHERE id IN (?)");
pstmt.setString(1,ids);
...

this code does not work; following error occurs -

- ORA-01722: invalid number.

I think because String s in result query is within apostrophe -
...IN('1,2,3,4')
instead of ...IN(1,2,3,4).
Is there any ideas for my problem? Thanks.