title: calling a package from shell script
body: <p>I have a package create with multiple procedure defined. I am trying to call this package from shell script.
  My package is written under schema ADM.
  Package name is: PK_COMPUTE_FIELDS.</p>
  
  <pre><code>CREATE OR REPLACE PACKAGE ADM.PK_COMPUTE_FIELDS AS
  PROCEDURE computeBalTotal(p_prd_id in integer,p_seg_id IN integer);
    PROCEDURE computeBilAmt(p_prd_id in integer,p_seg_id IN integer);
    PROCEDURE computePaidAmt(p_prd_id in integer,p_seg_id IN integer);
    END PK_COMPUTE_FIELDS ;
  CREATE OR REPLACE PACKAGE BODY ADM.PK_COMPUTE_FIELDS 
  AS
  PROCEDURE computeBalTotal(p_prd_id in integer,p_seg_id IN integer) IS
  BEGIN
  //derivation logic
  END;
    PROCEDURE computeBilAmt(p_prd_id in integer,p_seg_id IN integer)  IS
  BEGIN
  //derivation logic
  END;
  
    PROCEDURE computePaidAmt(p_prd_id in integer,p_seg_id IN integer)  IS
  BEGIN
  //derivation logic
  END;
  
  END PK_COMPUTE_FIELDS ;
  </code></pre>
  
  <p>I am using the below shell script to call this package</p>
  
  <pre><code>sqlplus -s &lt;USER&gt;/&lt;PWD&gt;@&lt;DBNAME&gt; &lt;&lt;EOF &gt;&gt; $LOG_NAME
  
  set serveroutput on
  whenever sqlerror exit failure rollback
  DECLARE 
    P_PRD_ID NUMBER;
    P_SEG_ID NUMBER;
  
  BEGIN 
    P_PRD_ID := 1907;
    P_SEG_ID := 1;
  
   execute immediate ADM.PK_COMPUTE_FIELDS.computeBalTotal( P_PRD_ID, P_SEG_ID );
    COMMIT; 
  END; 
  
  /
  EOF
  </code></pre>
  
  <p>I am getting an error as:</p>
  
  <pre><code>ERROR at line 9:
  ORA-06550: line 9, column 20:
  PLS-00201: identifier 'ADM.PK_COMPUTE_FIELDS.computeBalTotal' must be declared
  ORA-06550: line 9, column 2:
  PL/SQL: Statement ignored
  </code></pre>
  
  <p>Please guide me to correct this issue.</p>