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

1 vote137 views1 answer
Generate random data postgresql
SQL
0 vote134 views1 answer
MySQL INSERT IGNORE Statement
SQL
1 vote131 views1 answer
Show table columns
SQL
0 vote248 views1 answer
Sql server query all database objects
SQL
12 votes128 views4 answers
SQL Where
SQL
0 vote193 views1 answer
SQL Server Altering Column to be Unique
SQL
6 votes139 views1 answer
Oracle desc table primary key
SQL
19 votes149 views6 answers
Mysql if null
SQL
0 vote136 views1 answer
Sql count * vs count 1
SQL
1 vote143 views1 answer
Display total number of tables in mysql
SQL