This discussion is archived
3 Replies Latest reply: Jul 26, 2013 1:00 PM by InoL RSS

Executing Stored Procedure Within Package Over Database Link

f1f7a787-7f56-4451-8300-5a9a0215226b Newbie
Currently Being Moderated

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points