CODEWITHSUNDEEP
sqloracle-databaseplsqloracle12cpls-00201
en Lopes
en Lopes

Reputation: 2133

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

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

Upvotes: 0

Views: 1036

Answers (1)

Barbaros Özhan
Barbaros Özhan

Reputation: 65323

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...

Upvotes: 2

Related Questions