title: Set an out parameter value from a pl/sql block stored in a clob column
body: <p>I have the following table and relevant column.. </p>
  
  <pre><code>TABLEA
  SQL_SCRIPT    CLOB
  </code></pre>
  
  <p>Here is a procedure that executes the pl/sql block in the clob..</p>
  
  <pre><code>Create procedure (p_exit_code IN OUT NUMBER)
  AS
  V_sql_val   sql_script%TYPE;
  …
  BEGIN
  Select sql_script into v_sql_val from tablea;
  
  EXECUTE IMMEDIATE sql_script;
  
  END;
  </code></pre>
  
  <p>In SQL_SCRIPT I am trying to do following in the exception handler:</p>
  
  <pre><code>EXCEPTION
    WHEN EXCP_STOP_PROCESS THEN
      p_exit_code := 1;
  END;
  </code></pre>
  
  <p>I need to set the value of p_exit_code parameter in procedure from the clob script. How can I do this?</p>