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 vote181 views1 answer
Sql select all from one table and one column from another
SQL
0 vote178 views1 answer
Test sql query
SQL
5 votes182 views2 answers
Umgebungsvariable setzen für mysql 8
SQL
3 votes165 views1 answer
Make a field auto_increment mysql
SQL
0 vote168 views1 answer
Create new table pl sql
SQL
0 vote175 views1 answer
Sql shell psql cannot enter password
SQL
5 votes177 views1 answer
Oracle create table comment
SQL
0 vote166 views1 answer
How to increase the width of the screen in oracle
SQL
6 votes215 views2 answers
Mysql convert timestamp to date
SQL
3 votes166 views1 answer
Oracle revoke
SQL