Hi,

I have create a procedure using the dba account and the procedure can be executed using this account. Then, I have grant execute on <procedure name> to mooks. However, when i execute the procedure as mooks, i got the following error.

BEGIN <procedure name>; END;

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

Are there any other privileges that I have to grant to mooks before executing the procedure? I have tried grant create procedure to mooks and it doesnt work. Thanks!