title: Oracle Package Errors
body: <p>I am running a jrxml file that calls an oracle package and am getting this error:</p>
  
  <pre><code>java.sql.SQLException: 
  ORA-06550: line 1, column 14: PLS-00302: component 'EXAMPLE_PACK' must be declared 
  ORA-06550: line 1, column 7: 
  PL/SQL: Statement ignored. 
  </code></pre>
  
  <p>This package however, has grant of Execute and debug.</p>
  
  <pre><code>GRANT EXECUTE,DEBUG ON EXAMPLE_PACK TO USER;
  </code></pre>
  
  <p>Edit</p>
  
  <p>Spec ----</p>
  
  <pre><code>CREATE OR REPLACE PACKAGE tbaadm.fin_atmgl_pack
  AS
     PROCEDURE fin_atmgl_proc (inp_str       IN     VARCHAR2,
                               out_retcode      OUT NUMBER,
                               out_rec          OUT VARCHAR2);
  END fin_atmgl_pack;
  /    
  </code></pre>