3 Replies Latest reply: Jan 7, 2013 8:05 AM by Richard Harrison . RSS

    DBMS DATAPUMP procedures called from remote

    tyomasun
      Hi,
      how/is possible to call a procedure (thru) dblink, in which a statement call exists to DBMS_DATAPUM.OPEN ?
      I need to achieve this:
      On server S1(userS1/passwdS1):
      create procedure ProcWith_DATAPUMP
      begin
      handle:= DBMS_DATAPUMP.OPEN(...)
      end;
      On server S2:
      - create dblink DB_LINK_S1 to S1 identified by userS1/passwdS1;
      - call ProcWith_DATAPUMP@ DB_LINK_S1;
      is it possible ? in my case it fails with : ORA-31626: job does not exist

      Thanks