title: SYS_REFCURSOR as OUT parameter
body: <p>I have a table contains <code>(username-primarykey,password,age,gender);</code></p>
  
  <p>have to create procedure like <code>procedure(username in varchar,s_cursor out sys_refcursor);</code></p>
  
  <p>procedure has to accept <code>username</code> and returns row (<code>where username=in parameter</code> )as cursor.</p>
  
  <p>Rule:Cursor must and should be having unique sequence no along with the record it gives. 
  example:<code>(unique no(sequence),username ,password,age,gender)</code></p>
  
  <p>Every time procedure should return single record along with uniqueno(sequence)</p>