[急]ORACLE 9i 使用函数返回表报错 无法从非嵌套表访问行

Question

CREATE OR REPLACE FUNCTION F_CSJ_09(V_RQ IN VARCHAR2) RETURN T_CSJ_09
PIPELINED AS
V_OBJ_CSJ_09 OBJ_CSJ_09;

V_CSKJ NUMBER(4) := 0;
V_YXJS NUMBER(4) := 0;
V_YXL NUMBER(5, 2) := 0;
V_RZYL NUMBER(10, 4) := 0;
V_PJDJZY NUMBER(10, 4) := 0;
V_LJZC NUMBER(10, 4) := 0;

V_COUNT NUMBER(3);

CURSOR V_SJ IS
SELECT LX, MC, XH FROM V_XGGZ_ZQQKTJ;

BEGIN
FOR C_1 IN V_SJ LOOP

V_OBJ_CSJ_09 := OBJ_CSJ_09(C_1.XH,
                           C_1.MC,
                           V_CSKJ,
                           V_YXJS,
                           V_YXL,
                           V_RZYL,
                           V_PJDJZY,
                           V_LJZC);

PIPE ROW(V_OBJ_CSJ_09);

END LOOP;
RETURN;
END F_CSJ_09;

10g以上是好的

Answer 1

https://blog.csdn.net/iteye_20954/article/details/81524298