title: Is possible to get a constant value declared in a database package? (SQL or Java)
body: <p>I have some Packages in a Oracle database. They contain stored procedures, functions and constants. I can call functions, in Java, using a Java CallableStatement. Also, I could execute a SQL statement as "select package1.function1(value1) from dual;". But I can't find how to get the value of a constant declared in the package, in Java.</p>
  
  <p>For example:</p>
  
  <pre><code>PACKAGE Package1 AS
      A_CONSTANT CONSTANT VARCHAR2 := 'Constant value';
  END Package1;
  </code></pre>
  
  <p>Thanks.</p>