Stored Procedure ora-00942 when ora-00942 table or view does not exist

Stored Procedure ora-00942 when ora-00942 table or view does not exist

Solution:

Grant select, insert, update, delete on bookmarks. * to bm_user @ localhost identified by 'Password'

Authorization statement: Grants the XXX select, insert, update, and delete permissions to the bm_user table.

Log on to the system as sys and grant the select and delete sys. fga_log $ permissions to the system. Otherwise, the following stored procedure may be added.
SQL> grant select, delete on sys. fga_log $ to system;

Cause:
Later, I found out that if the user has a dba role, the permissions contained in the role will not be inherited in the stored procedure; so I separately granted explicit permissions to tb_bil_acct_566, seq_bil_acct_hisid_566.nextval, etc, solve the problem.

Http://blog.csdn.net/zhangtian0913/archive/2009/03/09/3973484.aspx

Where can I see the Authorization result of grant authorization?

Grant select, delete on sys. fga_log $ to system; -- which base table is changed? -- Dba_tab_privs



Select * from dba_tab_privs where grantee = 'system' AND TABLE_NAME = 'fga _ LOG $ '[@ more @] grant select, delete on sys. fga_log $ to system; -- which base table is modified? -- Dba_tab_privs



Select * from dba_tab_privs where grantee = 'system' AND TABLE_NAME = 'fga _ LOG $

Ora-00942 table or view does not exist

First, make sure that the tables or views that do not exist in the reports or views do not exist. If they do not exist, there is a problem with the export. just re-import them.
If a table exists, try re-compiling the stored procedure in PLSQL first. Can you check it?
In general, if tables and stored procedures belong to a USER, this can be solved,
Try it first. If not, it may belong to different users.
You can check whether SELECT * FROM DBA_ORJECTS where object_name = 'table name or stored procedure name' belongs to the same USER, hoping to help you.

Oracle Stored Procedure compilation error: PL/SQL: ORA-00942: Table or view does not exist row: 42 text: elsif G

I did not take a closer look. I was dizzy when I saw this:

FROM CC_STAND_BOM
Where item = ITEM
And code = CODE
AND bom_ver = bom_ver
And company = COMPANY
Group by item, ITEM_D, ITEM_CLASS, ITEM_D_CLASS;

Excuse me:
ITEM = ITEM
CODE = CODE
Company = COMPANY

Which of these are variables and which are field names?

The variable name and field name are inconsistent. The variable name can be p_xxx, which is different from the field name.

For example:
ITEM = p_ITEM