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

5 votes143 views4 answers
Sql check
SQL
0 vote114 views1 answer
Virtuoso sql query tutorial
SQL
0 vote117 views1 answer
Mysql check if lowercase
SQL
12 votes107 views2 answers
Select into insert sql server
SQL
1 vote102 views1 answer
Postgres get month name from date
SQL
5 votes102 views1 answer
Mysql select greater than yesterday
SQL
0 vote110 views1 answer
Query to get all primary keys and foreign key
SQL
0 vote115 views1 answer
Get last three characters in mysql column
SQL
0 vote95 views1 answer
Sqlite to csv statement
SQL
7 votes106 views1 answer
Mysql remote connection command line
SQL