This discussion is archived
7 Replies Latest reply: Jul 26, 2013 10:34 AM by Solomon Yakobson RSS

How to dbms_output a SYS_REFCURSOR in 10g???

Priscila_z Newbie
Currently Being Moderated

I have this procedure:

 

PROCEDURE TOP_ALARMAS_EXTERNAS(p_startDate in date,

                                                 p_endDate   in date,

                                                 p_txtAlarma in varchar2 default '%',

                                                 p_supervision in varchar2 default '%',

                                                 p_sitios out sys_refcursor)

as

Begin

open p_sitios for

select col1, col2

from myTable;

 

exception when others then

dbms_output.put_line('Error '||sqlerrm);

 

 

end;

 

And i need to see p_sitios from an output, how can i do that??

 

Thanks!

 

Priscila

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points