To declare an object in PL/SQL
Hi all,
The error "PLS-00201: identifier 'A.TEST' must be declared" was returned when user B have created a procedure as below
Code:
CREATE or REPLACE PROCEDURE TEST is
CURSOR T IS
SELECT id FROM a.test; <<<< Error in this line
BEGIN
....
END TEST;
I already granted SELECT on every B's tables to user A and also user B can query them.
What should I/user B do next?
Re: To declare an object in PL/SQL
Quote:
Originally posted by peach_partner I already granted SELECT on every B's tables to user A and also user B can query them.
What should I/user B do next?
Perhaps grant SELECT on A.test to B?