title: Executing SQL Function using toad
body: <p>I am very new to DB. I am java developer and nothing to do with SQL Functions.
  But now I am in a situation where I need to check whether an sql function is getting executed properly on db or not</p>
  
  <pre><code>CREATE OR REPLACE FUNCTION RATELIMIT_OWN.Get_Logs ( p_yyyymm VARCHAR2, p_numec NUMBER )
  RETURN LOG_RECORD_TABLE PIPELINED IS
  
  TYPE        ref0 IS REF CURSOR;
  cur0        ref0;
  
  out_rec     LOG_RECORD := log_record(NULL,NULL,NULL);
  
  BEGIN
  
  OPEN cur0 FOR
    'SELECT eventid, errormsg, create_date from logs partition (LOGS_P' || p_yyyymm || ') where numec=:1'
  USING p_numec;
  
    LOOP
     FETCH cur0 INTO out_rec.eventid, out_rec.msg, out_rec.create_date;
     EXIT WHEN cur0%NOTFOUND;
     PIPE ROW(out_rec);
    END LOOP;
    CLOSE cur0;
  
  RETURN;
  END Get_Logs;
  /
  </code></pre>
  
  <p>How to execute this sql function in toad. I want to see the results like normal Select query output</p>