Oracle does not find data in incoming arguments to the in statement

In is used in Oracle string, but no data is found

1 string " SELECT * from TB_YBSH where ID in:ids " ; 2 New OracleParameter ("ids", IDS); 3 DataTable dt = dbhelperora.executetable (getmodel,p);

Direct stitching is available

string " SELECT * from TB_YBSH where ID in "+ids;

But still want to use parameter query, on-line search, found the use of InStr, so written, problem solving

string " SELECT * from Tb_ybsh where InStr (: Ids,id) >0 "  New OracleParameter ("ids"= dbhelperora.executetable ( GETMODEL,P);

Reference http://overloving.iteye.com/blog/1638769

Oracle does not find data in incoming arguments to the in statement