title: package name is the same as another schema name in ORACLE PL/SQL, how to access another schema object?
body: <p>There are 2 schemas in database.
  <strong>HR schema</strong> and <strong>USER2</strong> schema,
  HR creates <strong>package named 'USER2'</strong> in his <strong>own schema</strong>,
  After if HR needs to call any object from USER2 schema all calls refer to 'USER2' package of its own schema, but not USER2 schema. How can HR call USER2 schema objects in this case?</p>
  <pre><code>create or replace function user2.func  -- function FUNC in USER2 schema
  return varchar2
  is
  begin
    return 'in USER2 schema';
  end;
  
  
  create or replace package user2  -- package USER2 in HR schema
  is
    function func return varchar2; -- function FUNC in USER2 package of HR schema
  end;
    
  create or replace package body user2 
  is
    function func return varchar2
    is
    begin
      return 'in HR schema';
    end;
  end;
  
  select user2.func from dual; -- RESULT OUTPUT &gt;&gt; 'in HR schema'
  </code></pre>