title: How to call another Procedure in CASE WHEN in Oracle Procedure
body: <p>I have created many Procedures to extract the data from remote database and stored it in my local database tables. The procedures run successfully when i run it individually. But now i want to create dynamic procedure which will call based on conditions. I have created small procedure for the same but getting an error when i run this procedure as : </p>
  
  <pre><code>ORA-06512: 
  01403. 00000 -  "no data found"
  </code></pre>
  
  <p>I am calling the procedure as <code>EXT_EXTRACTION(1000161);</code>
  I think the problem is i am not calling the Procedure in <code>CASE WHEN</code> properly and don't know how to call it correctly.</p>
  
  <p>Here is my procedure;</p>
  
  <pre><code>PROCEDURE "EXT_EXTRACTION"(
     IN_KPI_DEF_ID IN NUMBER DEFAULT 0
  ) AS 
    ENTITY_CLASS_NAME Number := 0;
    IN_EVENT_ID NUMBER;
  BEGIN
    Select EVENT_ID 
      INTO IN_EVENT_ID 
      from RATOR_MONITORING_CONFIGURATION.KPI_DEFINITION 
     WHERE KPI_DEF_ID = IN_KPI_DEF_ID;
    CASE 
      WHEN IN_EVENT_ID = 10049 
      THEN EXT_10049_ACTIVATE_OPTION;
    END CASE;
  
    COMMIT; 
  END EXT_EXTRACTION;
  </code></pre>