Resolve “PLS-00201: identifier ‘TABLE_NAME’ must be declare” while trying to compile PL/SQL procedure.
Note: table is actually a synonym from another schema.
-
Resolve “PLS-00201: Identifier 'TABLE_NAME' Must Be Declare” While Trying to C...
smallwei
2:11 pm on October 12, 2009 |
Answers: 1
Tags: identifier (4), name (14), pl sql (2), pls, resolve (6), schema (2), sql (42), sql procedure, synonym, table (15)
Rate Knowledge:
(1 votes)
Loading ...
smallwei 2:15 pm on October 12, 2009
When executing a SELECT statement, you need to have the SELECT privilege on the specific table, regardless of how you get to it.
However, to compile a procedure that selects from a table in another schema, you must have the SELECT privilege granted “explicitly”.