Error(66,3): PLS-00201: identifier must be declared

Question

I have 1 procedure in with the user CC_DEVICE . In this procedure I have this statement calling a procedure of another user.

of_device.p_msg.parse_csd_session(p_message);

But I got this error when compiling the package:

Error(66,3): PLS-00201: identifier 'OF_DEVICE.P_MSG' must be declared

You may not have permissions and need to grant it. With the `of_device` user run `GRANT EXECUTE ON of_device.p_msg TO your_current_user;` — MT0, Oct 05 '17 at 12:54

score 2 · Accepted Answer · answered Oct 05 '17 at 12:57

2

you should be granted to use that procedure with :

SQL> conn of_device/pwd1
SQL> grant execute on p_msg to cc_device
SQL> conn cc_device/pwd0

now you can use it from cc_device...

answered Oct 05 '17 at 12:57

Barbaros Özhan

1 Answers1