Java script in adobe campaign workflow
var result1 = sqlSelect("rec_cnt, @rec_cnt:Int64", "SELECT count(*) from pl_aud_interaction where business_unit_cd in ('BTXU','BTXN') and file_id in (select file_id from pl_aud_file_detail where batch_id in (+ batch_id_btxu +, + batch_id_btxn +))");When i run this i found below error code:07/09/2018 10:42:00 AM Oracle error: ORA-00936: missing expression07/09/2018 10:42:00 AM SQL statement 'SELECT count(*) from pl_aud_interaction where business_unit_cd in ('BTXU','BTXN') and file_id in (select file_id from pl_aud_file_detail where batch_id in (+ batch_id_btxu +, + batch_id_btxn +))' could not be executed (error in position 1707/09/2018 10:42:00 AM 3: ',').However the below similar code works fine when i execute :var result1 = sqlSelect("rec_cnt, @rec_cnt:Int64", "SELECT count(*) from pl_aud_interaction where business_unit_cd in ('BTXU','BTXN') and file_id in (select file_id from pl_aud_file_detail where batch_id= " +batch_id+ ")");Can someone please suggest where i am goi