title: ORACLE PL SQL PROCEDURE WITH MULTIPLE IF
body: <p>Is it correct to declare multiple <code>IF</code>s on PL SQL like the code below. I JUST GOT THIS ERROR --</p>
  
  <blockquote>
    <p>PACKAGE BODY HAS PROBLEMS ...could not find program unit being called</p>
  </blockquote>
  
  <pre><code>PROCEDURE CONSULTA_EVALCT(VAR_R VARCHAR2,VAR_A VARCHAR2, IO_CURSOR OUT T_CURSOR) 
  IS         
  V_CURSOR T_CURSOR; 
  BEGIN
  IF(VAR_R='0' AND VAR_A='0')THEN 
      OPEN V_CURSOR FOR 
      SELECT *from table1; 
      IO_CURSOR := V_CURSOR; 
  END IF; 
  IF(VAR_R='0' AND VAR_A&lt;&gt;0) THEN 
      OPEN V_CURSOR FOR
      SELECT *FROM table2; 
      IO_CURSOR := V_CURSOR; 
  END IF; 
  IF(VAR_R&lt;&gt;'0' AND VAR_A&lt;&gt;0) THEN
      OPEN V_CURSOR FOR
      SELECT *FROM table3; 
      IO_CURSOR := V_CURSOR; 
  END IF; 
  END CONSULTA_EVALCT;
  </code></pre>