title: Calling one procedure from another procedure
body: <p>The code below is saved in a file named proc1.sql</p>
  
  <pre><code>DECLARE
      B VARCHAR2(25);
      C NUMBER;
  
  PROCEDURE Get_manager_detailS(NO IN NUMBER,NAME OUT VARCHAR2,SAL1 OUT NUMBER)
  IS
  BEGIN
      SELECT ENAME, SAL 
      INTO NAME, SAL1 
      FROM EMP 
      WHERE EMPNO = NO;
  END;
  BEGIN
  Get_manager_detailS(7900,B,C);
  DBMS_OUTPUT.PUT_LINE(B);
  DBMS_OUTPUT.PUT_LINE(C);
  END;
  /
  </code></pre>
  
  <p>This procedure is stored in another file proc3.sql</p>
  
  <pre><code>PROCEDURE Test_Procedure()
  IS
  BEGIN
  b varchar2(25);
  c number;
  DBMS_OUTPUT.PUT_LINE('CALLING');
   Get_manager_details(7900,b,c);
  END;
  </code></pre>
  
  <p>When I am running it in sqlplus, it is showing an error</p>
  
  <blockquote>
    <p>SP2-0734 UNKNOWN COMMAND BEGINING PROCEDURE.. REST OF THE LINES IGNORED.
    SP2-0042 UNKNOWN COMMAND" IS "..REST OF THE LINE IGNORED.</p>
  </blockquote>