Shulou(Shulou.com)06/01 Report--

A few days ago, I wrote a stored procedure that needed to access the fields of the remote database, so I set up a dbLink and built a synonym:

CREATE PUBLIC DATABASE LINK orcl@dbc CONNECT TO orcl IDENTIFIED BY orcl USING 'orcl';CREATE SYNONYM mtb FOR mytable@orcl@dbc

The reason for using the name orcl@bdc as dblink here is to set up global_names=true.

Then create a new stored procedure to call the synonym:

V_result mtb.sid%type

Prompt: error: PLS-00201: identifier 'MTB.SID' must be declared

After many searches, it is found that it is really due to identity reasons. It is important to note that permissions must be granted in the accessed database. The specific code is as follows:

Grant select on mytable to orcl;--orcl is the user name

And then compiled and passed.

Summary

The above is an error in calling DBLink synonyms in the Oracle newspaper storage process introduced by the editor: PLS-00201: we must declare the identifier. I hope it will be helpful to you. If you have any questions, please leave me a message and the editor will reply to you in time. Thank you very much for your support to the website!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.