title: Use global type instead of the local subtype with same name
body: <p>I have a oracle database with several packages and some types. There is a type defined like</p>
  
  <pre><code>create or replace type my_type as table of varchar2(4000)
  </code></pre>
  
  <p>And then, into <code>pkg_machines</code> there is</p>
  
  <pre><code>subtype my_type is varchar2(4000)
  </code></pre>
  
  <p>Now, I didn't write the database and while analyzing errors I discovered that several packages do use <code>pkg_machines.my_type</code>, but <code>pkg_machines</code> needs to use both the local and the global one.</p>
  
  <p>The only possible way that came in my mind to do this, is to change the name of the subtype and refactorize every other package that uses it, but it would mean to waste a lot of time on refactoring hundreds of packages.</p>
  
  <p>My question is: is there a way to tell to a procedure to refer to the global type <code>my_type</code> instead of the defined subtype?</p>