asked on

need help executing procedure

I created a procedure as user A and grant execute on that privilege to user B however, every time i try to execute the procedure as user B i get the following error message.

Am I missing something?

execute COPYSTIRECORDTOBIBHOLDINGS
BEGIN COPYSTIRECORDTOBIBHOLDINGS; END;

*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'COPYSTIRECORDTOBIBHOLDINGS' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

woolmilkporc

BEGIN 'COPYSTIRECORDTOBIBHOLDINGS'; END;

wmp

sikyala

ASKER

the procedure name is COPYSTIRECORDTOBIBHOLDINGS

Sean Stuber

do you have a synonym owned by B pointing to that procedure? or a public synonym?

if not, you must prefix it with the owner

execute A.COPYSTIRECORDTOBIBHOLDINGS

or

BEGIN A.COPYSTIRECORDTOBIBHOLDINGS; END;

sikyala

ASKER

i tried creating a synonym but i keep getting the error

create synonym temsws.COPYSTIRECORDTOBIBHOLDINGS for temswsuser;
create synonym temsws.COPYSTIRECORDTOBIBHOLDINGS for temswsuser
*
ERROR at line 1:
ORA-00955: name is already used by an existing object

when i try to drop the synonym i get the error

ERROR at line 1:
ORA-01434: private synonym to be dropped does not exist

ASKER CERTIFIED SOLUTION

Sean Stuber

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

sikyala

ASKER

awseome thanks. Is it possible to view the text for that procedure logged in as temswsuser

SOLUTION

Sean Stuber

membership