Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
If a procedure has references to tables in it, you should always preface the table name with the name of the owner (creator) of the table.
When a procedure refers to a table, it uses the group memberships of the procedure creator to locate tables with no explicit owner name specified. For example, if a procedure created by user_1 references Table_B and does not specify the owner of Table_B, then either Table_B must have been created by user_1 or user_1 must be a member of a group (directly or indirectly) that is the owner of Table_B. If neither condition is met, a
table not found message results when the procedure is called.
You can minimize the inconvenience of long fully qualified names by using a correlation name to provide a convenient name to use for the table within a statement. Correlation names are described in FROM clause.