3 Replies Latest reply: Jul 26, 2013 3:00 PM by InoL RSS

    Executing Stored Procedure Within Package Over Database Link


      I'm currently trying to execute a stored procedure called "setuser" within a package called utils. I've set the grants for this package for execution and I'm using the following code for the execution.






      I'm getting the error...


      ORA-06550: line 2, column 26:
      PLS-00302: component 'SETUSER' must be declared
      ORA-06550: line 2, column 1:
      PL/SQL: Statement ignored


      1. begin
      2. ox_ERCIP_SRVY_RSCE.utils.setuser@ercip_link(:APP_USER);
      3. end;


      Can anybody point me in the right direction here please?


      Thank you,