pkg_checkproc.slideassign中跑一段重新分配成功,加上剔除口
select * from out_sale_task_d t where djbh='XSGYMA00671717';
select * from jc_fhtzlb t
DECLARE
O_RET VARCHAR2(50);
BEGIN
PKG_CHECKPROC.SLIDEASSIGN('600010', 'N', O_RET);
DBMS_OUTPUT.PUT_LINE(O_RET);
END;
select t.*,t.rowid from JC_FHTZLB t
WHERE SF_KY = '是'
AND FHTLX = '1'
AND ROWNUM = 1