PLSQL is table of %rowtype 转换cursor

Question

PLSQL is table of %rowtype 转换cursor

定义了一个
TYPE PlanDetail IS TABLE OF vrr_fdm_purPayPlanDetail%ROWTYPE;
p_list PlanDetail;

    plsql的out参数为：r_dataList      OUT retcursor,

    有没有大神帮帮忙！！！

Answer 1

DECLARE

CURSOR PlanDetail IS --声明游标

SELECT * FROM vrr_fdm_purPayPlanDetail;

    下面遍历游标就可以了，网上查一下oracle cursor的用法