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.






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,




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