Ibatis.net with oracle batch delete implementation code

The string to delete is ID

 
string SDSALES_IDString = 1,2,3,4,5,6,7 
// into Array 
Array array = SDSALES_IDString.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries).ToArray<string>(); 

Define 1 public Array SDSALES_IDs {get; set; }
XML:

 
<delete id="DeleteManyT_LABEL_SDSALES" parameterClass="T_LABEL_SDSALES"> 
DELETE FROM T_LABEL_SDSALES WHERE 
<isNotNull property="SDSALES_IDs"> 
SDSALES_ID IN 
<iterate property="SDSALES_IDs" conjunction="," open="(" close=")"> 
#SDSALES_IDs[]# 
</iterate> 
</isNotNull> 
</delete>