title: When I try to call one procedure inside another procedure I got this sql error "no function with name 'PROC_DISPLAY_FIRSTNAME' exists in this scope "
body: <p>I change my executable part as,</p>
  
  <pre><code>    BEGIN
        proc_ref_value(orders_id);
        proc_display_firstname(custId);
        DBMS_OUTPUT.PUT_LINE(orders_id||' '||status||'  '||re_value||' '||cust_last_name );
      END;
  </code></pre>
  
  <p>When I run It, I got output without customer full name.
       Statement processed.</p>
  
  <blockquote>
    <p>10101  completed  0 <br> 10102  cancelled  0 <br> 10103  completed  0
    <br> 10104  completed  0 <br> 10105  refunded  740 <br></p>
  </blockquote>
  
  <p>But I want to get customer full name from first procedure.  </p>