在程序中，执行下面代码
Sql sql=Sqls.create("SELECT p.RECORD_NO FROM PICTURE_INFO P "
+"WHERE EXISTS (SELECT 1 FROM REGISTER_INFO R "
+"WHERE P.RECORD_NO = R.RECORD_NO AND "
+"p.PARTITION_DATE<=@partitionDate AND r.DEPT_TYPE=@depType) "
+ "AND P.XML_INFO IS NOT NULL AND p.RECORD_NO NOT LIKE '%sacn' "
+ "AND P.STANDBY05 IS NULL AND ROWNUM <@count ORDER BY p.PARTITION_DATE ASC");
sql.setParam("partitionDate", date);
sql.setParam("depType", depType);
sql.setParam("count", count);
sql.setCallback(Sqls.callback.strList());
dao().execute(sql);
return sql.getList(String.class);
没有结果。工具执行是有的
