oracle synonym procedure dblink

Solutions on MaxInterview for oracle synonym procedure dblink by the best coders in the world

showing results for - "oracle synonym procedure dblink"
Giorgia
16 Jul 2016
1CREATE OR REPLACE SYNONYM syn_name_proc FOR my_schema.my_procedure@my_dblink;
2CREATE OR REPLACE SYNONYM syn_name_pkg my_schema.my_package@my_dblink;
3-- Call:
4BEGIN
5	syn_name_proc@my_dblink();							-- procedure
6	my_schema.syn_name_proc@my_dblink(param1, param2);	-- if parameters
7	syn_name_pkg.my_proc@my_dblink();					-- my_proc in a package
8END;