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

4 votes143 views1 answer
Restart for pg_hba.conf file
SQL
1 vote158 views1 answer
Alter database datafile maxsize 32g
SQL
0 vote152 views1 answer
Get db connection detail from sql developer profile
SQL
0 vote152 views1 answer
Less than and between in sql query
SQL
0 vote146 views1 answer
Qt qsql check if table exist
SQL
0 vote139 views1 answer
Sql delete where x or y or z
SQL
1 vote155 views1 answer
Psql import backup file for windows
SQL
0 vote162 views1 answer
Mysql get only the field names in a table
SQL
0 vote138 views1 answer
Is numeric in sql
SQL
0 vote157 views1 answer
Copied text from internet not inserting in mysql
SQL