-
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 to mooks. However, when i execute the procedure as mooks, i got the following error.
BEGIN ; END;
*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier '' 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!
-
-
Hi,
Thanks, i think i have solved the problem already. I think it could be that the procedure was not created as a public synonym which is why i cannot access it. Thanks anyway! :)