DECLARE
I_MEMBER_NO NUMBER;
O_CURSOR CPACCOUNTDB.PKG_MEMBER_ADDRESS_INFO.PKG_CS;
O_SP_RTN NUMBER;
TB_MEMBER_ADDRESS CP_MEMBER_ADDRESS%ROWTYPE;
BEGIN
I_MEMBER_NO := 3;
O_CURSOR := NULL; --Modify the code to initialize this parameter
O_SP_RTN := NULL;
CPACCOUNTDB.PKG_MEMBER_ADDRESS_INFO.GWS_MEMBER_ADDRESS_READLIST ( I_MEMBER_NO, O_CURSOR, O_SP_RTN );
LOOP
FETCH O_CURSOR INTO TB_MEMBER_ADDRESS;
EXIT WHEN O_CURSOR%NOTFOUND;
DBMS_OUTPUT.PUT_LINE(TB_MEMBER_ADDRESS.address_no);
DBMS_OUTPUT.PUT_LINE(TB_MEMBER_ADDRESS.address_main);
END LOOP;
COMMIT;
END;
이렇게 하니 DBMS Output 으로 출력이 되네요....
근데 GRID 로 출력하게 하는건 안되네영....다른 좋은 방법 아시는분 갈켜주세요.