title: overloading procedure in package
body: <p>Below is the HEADER for the Package TASK5</p>
  
  <pre><code>CREATE OR REPLACE PACKAGE TASK5 
      AS 
  PROCEDURE  TASK5APROCEDURE ( 
  REG_NO  IN  NUMBER,
  CERT_TITLE   OUT  VARCHAR2,
  E_DATE     OUT DATE,
      C_MARKS OUT INTEGER);
  
  
  PROCEDURE  TASK5BPROCEDURE ( 
  CERT_ID  IN  CHAR, 
  C_T OUT CHAR) ;    
  
   END TASK5;
  </code></pre>
  
  <p>The BODY for the PACKAGE TASK5 </p>
  
  <pre><code>CREATE OR REPLACE PACKAGE BODY TASK5 
  AS 
  
  
   PROCEDURE    TASK5APROCEDURE ( 
      REG_NO  IN  NUMBER,
      CERT_TITLE   OUT  VARCHAR2,
      E_DATE     OUT DATE,
      C_MARKS OUT INTEGER)
              IS
              BEGIN
  
  SELECT 
      O.PCP_TITLE, 
      C.CERT_EXAMDATE, 
      C.CERT_MARKS 
  
  INTO  
      CERT_TITLE, 
      E_DATE, 
      C_MARKS
  
  FROM 
      PROFCERTPROGRAM O
  INNER JOIN 
  CERTIFICATION C
      ON O.PCP_ID = C.PCP_ID
  WHERE 
      C.S_REGNO LIKE REG_NO;
  EXCEPTION
                 WHEN NO_DATA_FOUND
  THEN 
                    DBMS_OUTPUT.PUT_LINE('NO DATA FOUND');
  
  
  END TASK5APROCEDURE;
  
  
  PROCEDURE    TASK5BPROCEDURE ( 
  CERT_ID  IN  CHAR, C_T OUT CHAR)
              IS
      BEGIN
  
  DBMS_OUTPUT.PUT_LINE ('COURSE NAMES: ');
  
  FOR R IN (  
      SELECT O.C_TITLE C_T
  FROM 
      COURSE O
  INNER JOIN 
  CERTIFICATIONREQUIREMENT C
      ON O.C_ID = C.C_ID
  WHERE 
      C.PCP_ID LIKE '%'||CERT_ID||'%')
  
  LOOP
          DBMS_OUTPUT.PUT_LINE (R.C_T);
  END LOOP ;
  
  END TASK5BPROCEDURE;
  
  END TASK5;
  </code></pre>
  
  <p>I wrote the package with two different procedure for 2 different input. 
  But, I want to rewrite the header and body with overloading procedure, any suggestions? </p>