title: IF else condition in sql stored procedure
body: <p>I'm trying to compile the stored procedure:</p>
  
  <pre><code>create 
  procedure checkFroud2(code IN varchar2, p_recordset OUT SYS_REFCURSOR)
  AS
  BEGIN
  OPEN p_recordset FOR
  
  if code='C' then 
  select * from emp
  //dbms_output.putline('this is if block')
  else if code='F' then
  dbms_output.putline('this is else block')
  else
  dbms_output.putline('last else')
  end if;
  end checkFroud2;
  </code></pre>
  
  <p>but this is showing compile time errors. Can anybody suggest where the problem is?</p>