title: How to compile a Package using a psql command script
body: <p>We are creating a wrapper script (This script will be used to setup a db i.e create schema , Create table , Create packages etc)  which will call multiple scripts within it. This is how we have made the entry for creating a packages in the wrapper script. This pkg cosists of multiple procedures. </p>
  
  <p>\i RPT_glossary_pop_pkg.sql </p>
  
  <p>Following is the output in the tracefile created :- </p>
  
  <pre><code>QUERY
  --------------------------------------------------------------------------------
  CREATE OR REPLACE PACKAGE grs_rpt.grs_rpt_glossary_country_iou_pop_pkg 
  IS   
  PROCEDURE grs_rpt_glossary_pop_prc(); 
  --------------------------------------------------------------------------------
  </code></pre>
  
  <p>FYI. PKG spec definition is :-</p>
  
  <hr>
  
  <pre><code>-- Package: grs_rpt.grs_rpt_glossary_country_iou_pop_pkg
  
  -- DROP PACKAGE grs_rpt.grs_rpt_glossary_country_iou_pop_pkg;
  
  CREATE OR REPLACE PACKAGE grs_rpt.grs_rpt_glossary_country_iou_pop_pkg
  IS
  
  PROCEDURE grs_rpt_glossary_pop_prc();
  PROCEDURE grs_rpt_user_country_pop_prc();
  PROCEDURE grs_rpt_user_iou_pop_prc();
  
  END grs_rpt_glossary_country_iou_pop_pkg;
  </code></pre>
  
  <hr>
  
  <p>Is there a specific way to compile a package via such wrapper scripts? </p>
  
  <p>Please Suggest.</p>