Oracle synonym procedure dblink

CREATE OR REPLACE SYNONYM syn_name_proc FOR my_schema.my_procedure@my_dblink;
CREATE OR REPLACE SYNONYM syn_name_pkg my_schema.my_package@my_dblink;
-- Call:
BEGIN
	syn_name_proc@my_dblink();							-- procedure
	my_schema.syn_name_proc@my_dblink(param1, param2);	-- if parameters
	syn_name_pkg.my_proc@my_dblink();					-- my_proc in a package
END;

Similar codes

2 votes171 views1 answer
Update trigger
SQL
0 vote165 views1 answer
Select last 2 characters sql
SQL
1 vote199 views1 answer
Sql server loop over query
SQL
7 votes172 views1 answer
Sql server management studio turn on line numbers
SQL
0 vote185 views1 answer
Turn on foreign keys check mysql
SQL
0 vote327 views1 answer
Mysql workbench Error Code: 2013. Lost connection to MySQL server during query
SQL
5 votes159 views1 answer
Postgres integer to serial
SQL
0 vote161 views1 answer
C# mysql data reader from two tables
SQL
0 vote163 views3 answers
Select random sql
SQL
3 votes195 views2 answers
Synonym oracle
SQL