sql 代码
- CREATE OR REPLACE FUNCTION f_check_assert (paper_real_id IN VARCHAR2)
- RETURN NUMBER
- IS
- CURSOR csr_check
- IS
- SELECT SUM (ca.check_num)
- FROM t_capital_asserts ca
- WHERE EXISTS (
- SELECT 'X'
- FROM t_real tr
- WHERE tr.real_id != 0
- AND tr.status = 1
- AND tr.real_id = ca.real_id
- START WITH tr.real_id = paper_real_id
- CONNECT BY PRIOR tr.real_id = tr.parent_id);
- v_check NUMBER;
- BEGIN
- OPEN csr_check;
- FETCH csr_check INTO v_check;
- CLOSE csr_check;
- RETURN v_check;
- EXCEPTION
- WHEN OTHERS
- THEN
- DBMS_OUTPUT.put_line (SQLERRM);
- RETURN (NULL);
- END;
- /