title: How to install Oracle Java Extension?
body: <p>By running the following query:</p>
  
  <pre><code>SELECT   *
    FROM   XMLTABLE (
                     '
       declare function local:path-to-node( $nodes as node()* )  as xs:string* {
         $nodes/string-join(ancestor-or-self::*/name(.), ''/'')
       };
       for $i in $rdoc//name 
         return &lt;ret&gt;&lt;name_path&gt;{local:path-to-node($i)}&lt;/name_path&gt;{$i}&lt;/ret&gt;
      '
                     PASSING XMLPARSE (
                     CONTENT
                     '
        &lt;users&gt;&lt;user&gt;&lt;name&gt;user1&lt;/name&gt;&lt;/user&gt;
             &lt;user&gt;&lt;name&gt;user2&lt;/name&gt;&lt;/user&gt;
             &lt;group&gt;
                &lt;user&gt;&lt;name&gt;user3&lt;/name&gt;&lt;/user&gt;
             &lt;/group&gt;
             &lt;user&gt;&lt;name&gt;user4&lt;/name&gt;&lt;/user&gt;
        &lt;/users&gt;'
                     ) AS "rdoc" COLUMNS name_path varchar2 (4000) PATH
                     '//ret/name_path', name_value varchar2 (4000) PATH
                     '//ret/name')
  </code></pre>
  
  <p>I obtain the following error:</p>
  
  <pre><code>ORA-19112: error raised during evaluation:  
  ORA-06550: line 1, column 13:
  PLS-00201: identifier 'SYS.DBMS_XQUERYINT' must be declared
  ORA-06550: line 1, column 7:
  PL/SQL: Statement ignored
  </code></pre>
  
  <p>The problem is that Java has not been installed. While XQuery is executed via C in most cases 10.2.0.1.0 uses a Java based XQuery parser. </p>
  
  <p><strong>Please suppose that I have SYS and SYSTEM credentials.</strong></p>
  
  <p>How could I install Java for Oracle extension?</p>
  
  <p>Thank you in advance for your kind cooperation.</p>