ORA-00942 running PL/SQL script
Hello,
I've created a procedure and in the running time I've got that error.
Make sure your scheme must have privileges to the tables that you use in your cursor in pl/sql script. I run bellow code and It works to me now.
GRANT SELECT ON scheme_name.your_table_name TO your_scheme;
Loves,
I've created a procedure and in the running time I've got that error.
Make sure your scheme must have privileges to the tables that you use in your cursor in pl/sql script. I run bellow code and It works to me now.
GRANT SELECT ON scheme_name.your_table_name TO your_scheme;
Loves,
Comments
Post a Comment