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

7 votes205 views2 answers
Mysql check db size
SQL
12 votes170 views1 answer
Env var for setting password for root user mysql docker hub
SQL
0 vote192 views1 answer
Drop-toys-table
SQL
0 vote195 views2 answers
How to know the character set of an oracle databes
SQL
0 vote170 views1 answer
Redirection 301 htaccess nom de domaine
SQL
1 vote194 views1 answer
Sqlalchemy order by descending
SQL
0 vote220 views1 answer
Jpa generationtype sequence mysql
SQL
-1 vote186 views1 answer
SQL query to convert DD/MM/YYYY to YYYY-MM-DD
SQL
-2 votes199 views2 answers
Union vs union all in sql
SQL
1 vote188 views1 answer
Change default maximum runtime mariadb from phpmyadmin
SQL