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

    Executing Stored Procedure Within Package Over Database Link

    f1f7a787-7f56-4451-8300-5a9a0215226b

      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.

       

      begin

      ox_ERCIP_SRVY_RSCE.utils.setuser@ercip_link(:APP_USER);

      end;

       

      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,

       

      -Matty