C#调用Oracle存储过程并返回结果集

1.创建一个存储过程:

create or replace procedure GET_PERSON

(

    RC1 out sys_refcursor,

    RC2 out sys_refcursor

)

is

begin

    open RC1 for select * from PERSON;

    open RC2 for select