7 Replies Latest reply: Jul 26, 2013 12:34 PM by Solomon Yakobson RSS

    How to dbms_output a SYS_REFCURSOR in 10g???

    Priscila_z

      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