title: Calling an Oracle procedure within a package from a different schema?
body: <p>I've created the following package with 3 procedures:</p>
  
  <pre><code>CREATE OR REPLACE PACKAGE PQ_PaqueteIntegrantes
  AS 
  PROCEDURE INTEG_INSERCIONES(paIdIntegrante IN CreadorTablas.INTEGRANTES.ID_INTEGRANTE%TYPE 
                             ,paNombre IN CreadorTablas.INTEGRANTES.NOMBRE%TYPE
                             ,paApellidoPaterno IN CreadorTablas.INTEGRANTES.APELLIDO_PATERNO%TYPE);
  
  PROCEDURE INTEG_MODIFICACIONES(paIdIntegrante IN OUT CreadorTablas.INTEGRANTES.ID_INTEGRANTE%TYPE 
                                ,paNombre IN OUT CreadorTablas.INTEGRANTES.NOMBRE%TYPE
                           ,paApellidoPaterno IN OUT CreadorTablas.INTEGRANTES.APELLIDO_PATERNO%TYPE);
  
  PROCEDURE INTEG_ELIMINCACIONES( 
                 paIdIntegrante    IN OE.EJEMPLO_TRANSAC_CLASE.CUSTOMER_ID%TYPE
                                  ,paMjeDescError OUT VARCHAR2
                                  ,paCodeError    OUT NUMBER);             
  END PQ_PaqueteIntegrantes;
  </code></pre>
  
  <p>I created those procedures with a user called <strong>Admin_proyectos</strong>. The first procedures makes "Inserts", the second one "Updates", and the last one "Deletes", all of them working on a table called <strong>Integrantes</strong>, that table comes from another user called <strong>CreadorTablas</strong>.
  My intention is to create another user called <strong>Admin</strong>, who will have the responsibility to do those things, using the procedures from this package, of course. I've tried doing an PL/SQL block, but it didn't work, neither with an EXEC. </p>