ORA-06512 ORA-00942

ORA- Error:

BEGIN code_new_package.set_flag; END;
*
ERROR at line 1:
ORA-00942: table or view does not exist
ORA-06512: at "SCOTT.CODE_NEW_PACKAGE", line 56
ORA-06512: at line 1

 

Cause:

1. Package/procedure executed does not exist in database.

2. User executing package/procedure does not hold privilege to execute.

3. Public synonym missing on the package.

Solution:

1. Create the Package/procedure/table if it does not exist in database; verify existence using dba_objects view.

2. Grant execute privilege permission to the db user executing package/procedure.

grant execute on SCOTT.code_new_package to TOM ; 

3. Create publicPublic synonym missing on the package.

CREATE PUBLIC code_new_package FOR SCOTT.code_new_package;