SQL & PL/SQL

Hello gurus,

I got help from one of the guru from the OTN forum to write this procedure

here is how it looks similar to my proc

  create or replace procedure test_proc ( st_dt in date,
                                                         cv out sys_refcursor)
   as 
      begin
         Open cv for 
       select  a.col1,
                 a.col2,
                 b.col3,
 	b.col4
                 from tabl_1 a,
                      table_2 b
              where a.start_dt = st_dt
       
   end; 

   

Here is my question

         
         - I m opening the cursor and querying data. so once i open do i need to close the cursor  and i m also using OUT paramter?
         - But if i close the cursor, then will i be able to get the ouptut when i execute the procedure ?
         - Do i need to use cursor attribtes  ??
         
      

Thank you so much !!!