函数里
再放一个变量v_number
SELECT count(*) INTO v_number FROM SSYS.TSYS_USER WHERE EMPLOYCODE=userCode
看看v_number是多少?
再放一个变量v_number
SELECT count(*) INTO v_number FROM SSYS.TSYS_USER WHERE EMPLOYCODE=userCode
看看v_number是多少?
SELECT count(*) FROM SSYS.TSYS_USER WHERE EMPLOYCODE=12345;
而没有带引号!